Subquery

[Vicky]

Hi,

Is their a way that I can save the value of a field in an
array based on a query. Then run another query with its
criteria being that array. I was tring to create a sub-
query, but I was getting all the records.

Vicky

 

[JL]

Since I did not what you are trying to do.
I will just tell you the syntax a sub query is.

select id, ...... from table1 where id in (select id from
table2);

This will select all the records in table1 that have
matching id from table2.