sort by on two columns

From: "Andy Lewis" <jumboc(at)comcast(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: sort by on two columns
Date: 2004-01-03 01:15:49
Message-ID: 002101c3d197$20082f20$0201a8c0@andy2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bertrand Petit 2004-01-03 01:30:34 Re: Ambiguous error message
Previous Message Michael Fuhr 2004-01-03 01:05:19 Re: Ambiguous error message