- Local time
- Tomorrow, 02:50
- Joined
- Jan 20, 2009
- Messages
- 12,852
Pat, a GROUP BY without an aggregate function acts like an ORDER BY, or at least it did so the last time I tried it. (I admit it has been a while.)
I would have thought a query with Group By on all fields would result in the same results as a DISTINCT.