On Fri, 6 Jun 2003, scott.marlowe wrote:
> You probably want a join or a sub select.
>
> Or is it more complex than that?
Thank you to everyone who responded to my (very simple) question. Yes, it
was a subselect type op I wanted to do, but I didn't know that that was
what it was called.
I ended up with a query such as:
select table1.id2, fld2, table2.fld3
from table1, table2
where id = '1'
and table1.id2 = table2.id2
and fld2 > 0;
Cheers!
Jon
--
Jon Earle
SAVE FARSCAPE http://www.savefarscape.com/