nest a stored query...

[jvargas]

How do you reference as stored query in your SQL statements? Lets say im building a query that needs data from queryA results. Im guessing I would do something like this:

SELECT a, b, c FROM [tblA] WHERE b IN ([queryA].someField);

This doesnt work, the query is prompting me for a value of someField. I even tried to take out the ".someField" but still not working. What is the proper syntax for this?

Thanks

 

[Russell Hauf]

Somewhat confusing, but something like this should work:

• SELECT a, b, c FROM [tblA] WHERE b IN (Select someField from queryA);

Hope this helps,

Russell

 

[jvargas]

Somewhat confusing, but something like this should work:

• SELECT a, b, c FROM [tblA] WHERE b IN (Select someField from queryA);

Hope this helps,

Russell

Yeah, sorry.. i just realized that all i had to do was make a regular join and treat the query as a table.

Thanks