Subquery

  • Thread starter Thread starter Vicky
  • Start date Start date
V

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
 
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.
 
Back
Top