>
>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?>
>Yes, you were lucky. The fields that aren't included in GROUP BY clause are returned from the last physical record in the group. The ORDER BY clause doesn't have any effect on this because sorting's performed on the resulting recordset after it has been processed by HAVING clause and before it's written to the destination cursor/table/array/e.t.c.
>
This didn't jive with my memory - but you are quite right. Thanks for setting me straight.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site