If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IN (Select ... ) in Query criteria
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? -- THX cs |
#2
|
|||
|
|||
Sometimes a joined query will be non-editable, while the equivalent
query built using IN (Select...) will be editable. On Fri, 2 Sep 2005 12:19:01 -0700, Cydney wrote: 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? ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
#3
|
|||
|
|||
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? -- THX cs "Jack MacDonald" wrote: Sometimes a joined query will be non-editable, while the equivalent query built using IN (Select...) will be editable. On Fri, 2 Sep 2005 12:19:01 -0700, Cydney wrote: 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? ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How? Linking a select all box to a query field criteria line | Terri | Running & Setting Up Queries | 4 | May 24th, 2005 04:48 AM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 06:14 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Criteria using DateDiff function in SELECT Query. | EricB | Running & Setting Up Queries | 2 | September 24th, 2004 08:36 AM |