tdabek@go2.pl wrote:

Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT c.id AS id, CONCAT(UPPER(lastname), ' ', c.name) AS customername, status, address, zip, city, email, ten, ssn, c.info AS info, message, (SELECT COALESCE(SUM(value),0) FROM cash WHERE customerid = c.id ) AS balance FROM customersview c WHERE deleted = 0ORDER BY customername asc Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY customername asc' at line 4

poprawione, co ciekawe, postgres łykał takie zapytanie -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms