IN (Select ... ) in Query criteria

C

Cydney

Can someone please explain to me how and when to use an IN(Select ... )
statement in the criteria grid of a query? I've seen it used, but I don't
understand it. Why is that better than 2 joined tables?
 
J

Jack MacDonald

Sometimes a joined query will be non-editable, while the equivalent
query built using IN (Select...) will be editable.


Can someone please explain to me how and when to use an IN(Select ... )
statement in the criteria grid of a query? I've seen it used, but I don't
understand it. Why is that better than 2 joined tables?
Click to expand...

**********************
[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
C

Cydney

Ok, I think I understand that. You're actually working with data from the
first (main) table (which is editable) but only with the "select" data which
is matched in the "IN(Select.." criteria. Is that correct?

Is the "(Select..." portion of the criteria written just as you would any
SQL for a query? If not, can you give me a correct example of that syntax?
 
Top