SELECT * FROM customers ORDER BY last_name, first_name
Works for me.
----- Original Message -----
Sent: Saturday, January 03, 2004 8:15 AM
Subject: [SQL] sort by on two columns
Hi All,
Is it possible to sort by two columns? Using the query below?
SELECT table1.name, table2.name, <other selected columns> FROM table1, table2 WHERE table1.id = table2.id ORDER BY <what?>
I want to be able to sort the names select from two different tables and two different colums(same data type).
Is this possible?
Thanks,
Andy