Wow... so.. um... yeah. I don't understand how that works, but it works!

Thanks a lot for your help!

I'll have to study this one.

Didn't know you could do two...

Here's a better example of what I mean. I'm sorting based on different fields than what is being displayed.

SELECT Region, State, SUM(Sales) AS Sales

FROM Sales

GROUP BY

...

Thanks for the response. However, you may have misunderstood my question.

I already know that in my order by I don't need to include all the columns listed in my select...