On Sun, 14 Sep 2003, A.L.E.C wrote:

oba zapytania koncza sie nastepujaco...

<HERE (cash.type = 3 OR cash.type = 4) GROUP BY users.id, status HAVING status = 3; ERROR 1054: Unknown column 'status' in 'having clause'

<d WHERE (cash.type = 3 OR cash.type = 4) GROUP BY users.id, name, lastname, status HAVING status = 3 ORDER BY balance; ERROR 1054: Unknown column 'status' in 'having clause'

co ten MySQL taki glupi, w GROUP BY mu nie przeszkadza, a w HAVING tak? Spróbuj status zamienic na users.status

-- Pozdrawiam Aleksander Machniak ( A.L.E.C ) http://k27.prv.pl/alec GG-2275252