Query to include only entries between two tables that do not have a match

[Adam121212]

Hello,

I have two tables that I am trying to run a query on. Table 1 has about 60000 entries and table 2 has about 20000 entries. Table 1 includes all of table 2's entries so table 1 actually has about only 40000 unique entries. Every entry in both tables has an ID number that identifies each entry. Basically I am trying to run a query that will isolate table 1's unique entries from table 2's to give to give me a table which only includes table 1's unique entries and does not include any of the entries that are also in table 2. So far I have started to design a query and established the relationship between the ID numbers. How can I design the query so that it returns the entries that are unique only to table 1? The resultant table would have about 40000 entries.

Thanks

[CJ_London]

use a outer join. Something like

SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.ID=Table2.ID
WHERE Table2.ID is Null

[Missinglinq]

No sure I follow, completely, and never had cause to use it, but if you crank up the Query Wizard, one of the choices you get is to use the Find Unmatched Query Wizard...which sounds like might might be what you need.

Linq ;0)>

[Adam121212]

Did exactly what I needed. Thanks

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>