X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F356D1B4F6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 16:39:03 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 00980-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 13:38:16 -0300 (ADT)
Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150])
	by svr1.postgresql.org (Postfix) with ESMTP id 700AED1B52D
	for <pgsql-sql@postgresql.org>; Mon,  6 Oct 2003 13:38:15 -0300 (ADT)
Received: from wocker (wocker.unixathome.org [192.168.0.99])
	by bast.unixathome.org (Postfix) with ESMTP
	id E37F53D28; Mon,  6 Oct 2003 12:37:38 -0400 (EDT)
From: "Dan Langille" <dan@langille.org>
To: "Louise Cofield" <lcofield@box-works.com>
Date: Mon, 06 Oct 2003 12:39:43 -0400
MIME-Version: 1.0
Subject: Re: Multiple table join
Cc: pgsql-sql@postgresql.org
Message-ID: <3F81628F.2672.587C7E11@localhost>
In-reply-to: <002d01c38c26$aaa76990$7801a8c0@Louise>
X-mailer: Pegasus Mail for Windows (v4.02a)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/73
X-Sequence-Number: 15473

On 6 Oct 2003 at 10:26, Louise Cofield wrote:

> I am attempting to select fields Location and Item_Num from table A
> where A.Location = B.Location, 
> 
> AND 
> 
> select Item_Description from table C, where A.Item_Num = C.Item_Num.

Try:

select Location, Item_Num
from table A, B, C
where A.Location = B.Location
and A.Item_Num = C.Item_Num
-- 
Dan Langille : http://www.langille.org/