>>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
You are quite right - humble apologies for questioning.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site