Select from multiple tables

Поиск
Список
Период
Сортировка
От Jon Earle
Тема Select from multiple tables
Дата
Msg-id Pine.LNX.4.55.0306061114470.19934@kronos.honk.org
обсуждение исходный текст
Ответы Re: Select from multiple tables  ("Jim C. Nasby" <jim@nasby.net>)
Re: Select from multiple tables  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Select from multiple tables  (Richard Huxton <dev@archonet.com>)
Re: Select from multiple tables  (Ernest E Vogelsinger <ernest@vogelsinger.at>)
Re: Select from multiple tables  (Jonathan Bartlett <johnnyb@eskimo.com>)
Re: Select from multiple tables  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Hi,

I want to select data from two tables, with the keying information for the
second table coming from the select results of the first.  Can this be
done in one call, or will I need to resort to two calls - one to get the
record from the first table, then a second call to get the record from the
second table based on a key contained in the first results set?

Cheers!
Jon

--
Jon Earle

SAVE FARSCAPE http://www.savefarscape.com/

В списке pgsql-general по дате отправления:

Предыдущее
От: "Henrik Steffen"
Дата:
Сообщение: update phenomenom
Следующее
От: Darko Prenosil
Дата:
Сообщение: Re: EXTERN JOIN with WHEN query