From: Richard Huxton <dev@archonet.com>
To: blake@shopwhatcom.com (Blake), pgsql-sql@postgresql.org
Subject: Re: Proper SQL syntax requested
Date: Tue, 27 Apr 2004 13:06:42 +0100
User-Agent: KMail/1.5
References: <adb08a4b.0404211541.438e8cb5@posting.google.com>
In-Reply-To: <adb08a4b.0404211541.438e8cb5@posting.google.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200404271306.42790.dev@archonet.com>

On Thursday 22 April 2004 00:41, Blake wrote:
>
> 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??

You don't say which table contains the name in question. Assuming we want 
column make_name from table make_description with an id of make_id then:

SELECT floors.* FROM floors, make_description 
WHERE system=1 AND floors.make = make_description.make_id
ORDER BY make_description.make_name;

This is called a join. Any book on databases/SQL should discuss this sort of 
stuff.

-- 
  Richard Huxton
  Archonet Ltd