Quick Links

Select from multiple tables

From:	Jon Earle <je_pgsql(at)kronos(dot)honk(dot)org>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Select from multiple tables
Date:	2003-06-06 15:17:01
Message-ID:	Pine.LNX.4.55.0306061114470.19934@kronos.honk.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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/

Responses

Re: Select from multiple tables at 2003-06-06 18:20:00 from Jonathan Bartlett
Re: Select from multiple tables at 2003-06-06 18:20:02 from Bruno Wolff III
Re: Select from multiple tables at 2003-06-06 18:37:44 from Ernest E Vogelsinger
Re: Select from multiple tables at 2003-06-06 18:58:58 from Richard Huxton
Re: Select from multiple tables at 2003-06-06 19:08:28 from scott.marlowe
Re: Select from multiple tables at 2003-06-06 19:31:50 from Jim C. Nasby

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jonathan Bartlett	2003-06-06 15:17:37	Re: Nulls get converted to 0 problem
Previous Message	Jan Weerts	2003-06-06 15:16:23	Re: Nulls get converted to 0 problem