From: blake@shopwhatcom.com
To: pgsql-sql@postgresql.org
Subject: Proper SQL syntax requested
Date: 21 Apr 2004 16:41:57 -0700
Message-ID: <adb08a4b.0404211541.438e8cb5@posting.google.com> (raw)
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: blake@shopwhatcom.com
Subject: Re: Proper SQL syntax requested
In-Reply-To: <adb08a4b.0404211541.438e8cb5@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox