| From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
|---|---|
| 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:00 |
| Message-ID: | Pine.GSU.4.44.0306061119360.27725-100000@eskimo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This sounds like a simple join, could you give a more concrete example?
Jon
On Fri, 6 Jun 2003, Jon Earle 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?
>
> Cheers!
> Jon
>
> --
> Jon Earle
>
> SAVE FARSCAPE http://www.savefarscape.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-06-06 18:20:02 | Re: Select from multiple tables |
| Previous Message | Matthew Rudolph | 2003-06-06 18:13:15 | Speed/Performance with pg_restore |