Re: sort by on two columns

----- Original Message -----

From: Andy Lewis

To: pgsql-sql@postgresql.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