> I didn't know if this was possible and haven't tried yet. My boss wants > me to sort results by 3 columns (city, county, price.) He would like city > and county in alphabetical order a-z and have price from highest to > lowest. I told him I didn't think it was possible to sort two different > fields one acending and one descending.
All info you need is here: http://www.mysql.com/doc/en/Sorting_rows.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]