>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