Re: sort by on two columns

MessageSELECT * FROM customers ORDER BY last_name, first_name
Works for me.
----- Original Message -----
From: Andy Lewis
To: pgsql-sql(at)postgresql(dot)org
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