SQL: NOT IN (Select tradeid from qryGroup1;)

[leeloo0505]

Hello,

I need to make three seperate groups of trades. I have one file with all the data in it and have queried it and gotten results for one group. After identifying those trades by ID.. I need to get the remaining ID's that were not in my results.
Using the Design View of queries, I have tried selecting the tradeid from the main file and then in the criteria by writing: NOT In (Select tradeid from qrygroup1. The query will just run for a very long time, I don't know if its working or not? Any other ideas?

thanks,
leeloo

 

[Dugantrain]

I think that the way you're trying to do it will eventually work, but here's a better way. Join the two queries together on the ID field. Make the Join Type an Outer Join, returning all records from qrygroup2. Pull down the ID field from qryGroup1 deselect 'Show', and in the criteria for the field, write 'Is Null'. The Find Unmatched wizard, by the way, will perform this task for you.

 

[leeloo0505]

oops! didn't even see that feature... thanks for your time! Worked like a charm.

leeloo