Re: Multiple table join

Поиск
Список
Период
Сортировка
Искать
От
Dan Langille
Тема
Re: Multiple table join
Дата
Msg-id
3F81628F.2672.587C7E11@localhost
Ответ на
Multiple table join (Louise Cofield)
Список
Дерево обсуждения
Multiple table join "Louise Cofield" <lcofield@box-works.com>
Re: Multiple table join Bruno Wolff III <bruno@wolff.to>
Re: Multiple table join "Louise Cofield" <lcofield@box-works.com>
Re: Multiple table join "Dan Langille" <dan@langille.org>
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/


В списке pgsql-sql по дате отправления
От: Louise Cofield
Дата:
Сообщение: Re: Multiple table join
От: Josh Berkus
Дата:
Сообщение: Re: create new field
FAQ