Multiple table join

From: "Louise Cofield" <lcofield(at)box-works(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Multiple table join
Date: 2003-10-06 16:26:59
Message-ID: 002d01c38c26$aaa76990$7801a8c0@Louise
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2003-10-06 16:29:31 suggestion needed for implementation
Previous Message Bill Pfeiffer 2003-10-06 14:40:52 PG equivalent to Sybase varbinary