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 73DB7D1B51E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 16:31:30 +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-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 13:30:41 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id 37764D1B4FF
	for <pgsql-sql@postgresql.org>; Mon,  6 Oct 2003 13:30:40 -0300 (ADT)
Received: (qmail 27985 invoked by uid 500); 6 Oct 2003 16:38:04 -0000
Date: Mon, 6 Oct 2003 11:38:04 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Louise Cofield <lcofield@box-works.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Multiple table join
Message-ID: <20031006163804.GA27925@wolff.to>
Mail-Followup-To: Louise Cofield <lcofield@box-works.com>,
	pgsql-sql@postgresql.org
References: <002d01c38c26$aaa76990$7801a8c0@Louise>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <002d01c38c26$aaa76990$7801a8c0@Louise>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/69
X-Sequence-Number: 15469

On Mon, Oct 06, 2003 at 10:26:59 -0600,
  Louise Cofield <lcofield@box-works.com> 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.

Just list all three tables in the from item list and include both
conditions in the where clause (connected by and).

If there is more to your problem than this, you should supply more details.