Re: Multiple table join

From: "Dan Langille" <dan(at)langille(dot)org>
To: "Louise Cofield" <lcofield(at)box-works(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Multiple table join
Date: 2003-10-06 16:39:43
Message-ID: 3F81628F.2672.587C7E11@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-10-06 16:44:47 Re: create new field
Previous Message Bruno Wolff III 2003-10-06 16:38:04 Re: Multiple table join