Hi,
> I told him I didn't think it was possible to sort two > different fields one acending and one descending. But, of course, it is possible :) http://www.mysql.com/doc/en/SELECT.html SELECT ... ORDER BY city, county, price DESC Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]