From: milica.mihac@ck.htnet.hr   
      
   >    Cause: The GROUP BY clause does not contain all the expressions in   
   > the SELECT clause. SELECT expressions that are not included in a group   
   > function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must   
   > be listed in the GROUP BY clause.   
   >    Action: Include in the GROUP BY clause all SELECT expressions that   
   > are not group function arguments.   
      
      
      
   Hi, I already included in GROUP BY clause all SELECT expressions that   
   are not group function arguments.   
   And it runs OK in Oracle 8, but when I change version of Oracle in Oracle   
   9...then error start to appear.   
      
   Regards, Milica   
      
   >>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 name   
   >>from c02 t1, d00 t2   
   >>where t1.id = t2.id   
   >>and t1.date1 >= :pDate1   
   >>group by t2.nad, t2.id   <-- is this supposed to be t1.id?   
   >   
   > From Oracle's website: http://tinyurl.com/78fgq   
   >   
   > ORA-00979 not a GROUP BY expression   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)