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 3FE14D1B506 for ; Mon, 6 Oct 2003 16:28:18 +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 02349-01 for ; Mon, 6 Oct 2003 13:27:28 -0300 (ADT) Received: from ns.lanterm.net (unknown [208.187.178.11]) by svr1.postgresql.org (Postfix) with ESMTP id 65E1AD1B4EC for ; Mon, 6 Oct 2003 13:27:12 -0300 (ADT) Received: from Louise ([208.187.178.2]) by ns.lanterm.net (8.11.6/8.11.6) with ESMTP id h96FKLs05291 for ; Mon, 6 Oct 2003 09:20:21 -0600 From: "Louise Cofield" To: Subject: Multiple table join Date: Mon, 6 Oct 2003 10:26:59 -0600 Message-ID: <002d01c38c26$aaa76990$7801a8c0@Louise> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002E_01C38BF4.600CF990" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=HTML_70_80 X-Spam-Level: X-Archive-Number: 200310/68 X-Sequence-Number: 15468 This is a multi-part message in MIME format. ------=_NextPart_000_002E_01C38BF4.600CF990 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Greetings, SQL gurus! 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. Any help would be appreciated. Louise ------=_NextPart_000_002E_01C38BF4.600CF990 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Greetings, SQL gurus!

 

I am attempting to select fields Location and Item_Num f= rom table A where A.Location =3D B.Location,

AND

select Item_Description from table C, where A.Item_Num = =3D C.Item_Num.

 

 

Any help would be appreciated.

 

Louise

 

 

------=_NextPart_000_002E_01C38BF4.600CF990--