Compound Order By

[Robert Pruitt]

I'd like to do a dual order by. First, I want to order by City, then I 
want to order name. That way, the names within the city are alphabetized.

I can easily do an order by City into a temp table, then order by name 
from within the temp table. Is this the best way? Is this the only way?

Just wonderin'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]