Select from multiple tables

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/