Thank you Mark for clearing this up for me.
>Yes. Aggregated fields are the only ones that do not need to be in the GROUP BY. All else do.
>
>>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?
>
>Yes. Same as above.
>
- Ravi
True greatness consists in being great in little things.
- Charles Simmons