Postgres Pro
Downloads
Home   >   mailing lists

sort by on two columns - Mailing list pgsql-sql

From Andy Lewis
Subject sort by on two columns
Date
Msg-id 002101c3d197$20082f20$0201a8c0@andy2
Whole thread Raw
Responses Re: sort by on two columns
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Ambiguous error message
Next
From: Bertrand Petit
Date:
Subject: Re: Ambiguous error message