Not a group by expression
From: MM <milica.mihac_at_ck.htnet.hr>
Date: Wed, 11 May 2005 12:29:19 +0200
Message-ID: <d5smq2$d50$1_at_ss405.t-com.hr>
Hello users. I have a query that I can run and see the result on the grid on design time, but when i run the program i get the folowing message:ORA-00979: not a GROUP BY expression. When I run the same query with out parameters it runs and it was runing well before in Oracle 8.Also If I don't use the GROUP BY function but with the parameter, it works also well ?What is the problem? The query is:select t1.id,t2.nad,max(t2.name) as namefrom c02 t1,d00 t2where t1.id = t2.idand t1.date1>= :pDate1group by t2.nad, t2.idAny help is helpfull. Regards,MM Received on Wed May 11 2005 - 12:29:19 CEST
Date: Wed, 11 May 2005 12:29:19 +0200
Message-ID: <d5smq2$d50$1_at_ss405.t-com.hr>
Hello users. I have a query that I can run and see the result on the grid on design time, but when i run the program i get the folowing message:ORA-00979: not a GROUP BY expression. When I run the same query with out parameters it runs and it was runing well before in Oracle 8.Also If I don't use the GROUP BY function but with the parameter, it works also well ?What is the problem? The query is:select t1.id,t2.nad,max(t2.name) as namefrom c02 t1,d00 t2where t1.id = t2.idand t1.date1>= :pDate1group by t2.nad, t2.idAny help is helpfull. Regards,MM Received on Wed May 11 2005 - 12:29:19 CEST