>>What if there were 10 fields in teh select statement, has a Group By clause, and no aggregate functions. Should all the 10 fields be identified in the Group By clause, and in the order of how they should be grouped?
>>
>
>Henry,
>
>The order of columns in GROUP BY clause has no effect on grouping result.
Oh - thanks Sergey. I was wondering about that because Mark advised that all non-aggregate fields should be included in the Group By clause, regardless of how many fields there are in teh select statement.
Is there a way of doing a find in a development directory that would go into every form, prg and frx files to see where all the Group By caluses exist?
Thanks Sergey.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons