Re: [SQL] sort by on two columns

[Chris Travers]

Title: Message

SELECT * FROM customers ORDER BY last_name, first_name Works for me. ----- Original Message ----- From: Andy Lewis To: [EMAIL PROTECTED] 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