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 1BB0DD1B548 for ; Mon, 6 Oct 2003 16:36:27 +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 03253-01 for ; Mon, 6 Oct 2003 13:35:37 -0300 (ADT) Received: from ns.lanterm.net (unknown [208.187.178.11]) by svr1.postgresql.org (Postfix) with ESMTP id 4085FD1B52E for ; Mon, 6 Oct 2003 13:35:36 -0300 (ADT) Received: from Louise ([208.187.178.2]) by ns.lanterm.net (8.11.6/8.11.6) with ESMTP id h96FSxs05624; Mon, 6 Oct 2003 09:28:59 -0600 From: "Louise Cofield" To: "'Bruno Wolff III'" Cc: Subject: Re: Multiple table join Date: Mon, 6 Oct 2003 10:35:37 -0600 Message-ID: <003401c38c27$df7fbe50$7801a8c0@Louise> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-Reply-To: <20031006163804.GA27925@wolff.to> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/72 X-Sequence-Number: 15472 That was waaaaay too simple -- thank you! -----Original Message----- From: Bruno Wolff III [mailto:bruno@wolff.to] Sent: Monday, October 06, 2003 10:38 AM To: Louise Cofield Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Multiple table join On Mon, Oct 06, 2003 at 10:26:59 -0600, 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. 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.