Select from multiple tables - Mailing 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