Re: Not a group by expression
Date: Wed, 11 May 2005 17:57:26 +0100
Message-ID: <79e481d3bl3cs0nh4u325kbegjdqosiio6_at_4ax.com>
"MM" <milica.mihac_at_ck.htnet.hr> wrote:
>Hello users. I have a query that I can run and see the result on the grid on
Kako si? Give us the details of the DDL for the tables in question -
also, this question should really be asked on
comp.databases.oracle.server. Version number (exact) and OS info would
also help. Hvala.
Paul...
>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
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, As a courtesy to those who spend
time analyzing and attempting to help, please
do not top post.
Received on Wed May 11 2005 - 18:57:26 CEST