Re: Not a group by expression

"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
>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

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...

-- 

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.