On Sun, 14 Sep 2003, A.L.E.C wrote:
> > 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
i nic....
ani users.status HAVING status = 3
ani users.status HAVING users.status = 3
ani status HAVING users.status = 3
Pozdrawiam
Pawel Bernadowski
GG 3377, email kontakt(a)pbern.biz
