From: blake@shopwhatcom.com (Blake)
Subject: Proper SQL syntax requested
Date: 21 Apr 2004 16:41:57 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <adb08a4b.0404211541.438e8cb5@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
To: pgsql-sql@postgresql.org

Wondering if anyone can help me with the proper syntax for an ORDER BY
clause with a subquery. What I have is a table column named make in
one table. The make column contains a Serial ID of the name which is
stored in an alternate table named sections. I am trying to be able to
ORDER by on make, but as you can guess it is ORDERING by the ID rather
than the actual Name.

Select * from floors Where system = 1 ORDER by make

This sorts by the Serial ID's in column make

I would like to be able to sort by the actual Names associated back
from the ID's. Anyway of doing this??

Thanks All for the Help!