>>Interesting group of threads Sergey. I looked at several and found that I would have recommended an ORDER BY before the GROUP BY in order to specify which records are shown in the results. I've never had any problem as long as I used ORDER BY - have I been missing something?
>>
>
>Since ORDER BY isn't applied until you reach the final results, it doesn't affect grouping.
>
>Tamar

Hmmm... Both you and Serge tell me this is true, but it doesn't jive with my experience. I'll do a quick test... Memory can be decieving!