| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jon Earle <je_pgsql(at)kronos(dot)honk(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Select from multiple tables |
| Date: | 2003-06-06 18:20:02 |
| Message-ID: | 20030606182002.GB709@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jun 06, 2003 at 11:17:01 -0400,
Jon Earle <je_pgsql(at)kronos(dot)honk(dot)org> wrote:
>
> 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?
It sounds like you want to join the tables. It is hard to say for sure
since you haven't provided details about the tables and what you are
trying to get back.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ernest E Vogelsinger | 2003-06-06 18:37:44 | Re: Select from multiple tables |
| Previous Message | Jonathan Bartlett | 2003-06-06 18:20:00 | Re: Select from multiple tables |