Subject | not contained in either an aggregate ... |
---|---|
Author | tomas650220 |
Post date | 2004-04-08T12:52:29Z |
Hello,
I got this error message :
"Invalid expression in the roder by clause (not contained in either
ann aggregate function or the group by clause)"
if I ran select :
select zas.zbozi,kat.nazev,sum(konzasmn) from tbnv_zas
zas, tbnv_ktzbozi kat where
zas.zbozi = kat.zbozi
group by zas.zbozi, kat.nazev
order by zbozi
I understand that correct syntax of order by clause is
"order by zas.zbozi"
but on W9x and WinNT this select works.
Upper described error I got on W2000 and higher.
Can anyone tell me what is the reason ?
And second problem :
What does mean message :
"No current record for fetch operation"
Thanks
Tomá Jíra
I got this error message :
"Invalid expression in the roder by clause (not contained in either
ann aggregate function or the group by clause)"
if I ran select :
select zas.zbozi,kat.nazev,sum(konzasmn) from tbnv_zas
zas, tbnv_ktzbozi kat where
zas.zbozi = kat.zbozi
group by zas.zbozi, kat.nazev
order by zbozi
I understand that correct syntax of order by clause is
"order by zas.zbozi"
but on W9x and WinNT this select works.
Upper described error I got on W2000 and higher.
Can anyone tell me what is the reason ?
And second problem :
What does mean message :
"No current record for fetch operation"
Thanks
Tomá Jíra