Select from multiple tables - Mailing list pgsql-general

From Jon Earle
Subject Select from multiple tables
Date
Msg-id Pine.LNX.4.55.0306061114470.19934@kronos.honk.org
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: "Henrik Steffen"
Date:
Subject: update phenomenom
Next
From: Darko Prenosil
Date:
Subject: Re: EXTERN JOIN with WHEN query