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