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
>