Isolating Unique Values in a Comparison 1

[rjsmith24]

Ok, I check about 10 pages of threads to make sure this wasn't a duplicate post, sorry if it is.

I have two columns of phone numbers. 1 is the state do not call list. The other is my dialing list. I want to create a table of numbers in my dialing list that are NOT in the DO NOT CALL list. I'm having trouble just figuring the logic out, let alone the query- here's my thought.
Table Name: Numbers, NoCall is the do not call list, CallList is my set of numbers. The data currently resides in 2 different tables: DNC (do not call) and CL (call list).

Select CL.CallList
from CL inner join DNC on CL.CallList

So where do I go from here? Any help is greatly appreciated.
Robert

 

[NorthNone]

Run the "Find Unmatched Query Wizard" to find all the records in your call table that don't exist in you no-call table. Switch to SQL view and copy the SQL into your code. You'll have LOTS of extra parentheses that can be removed and "" may need to be changed to '' in some instances before it will run. HTH JeanS

 

[rjsmith24]

Awesome- a perfect solution- surprisingly, Access2002 kept the sql very clean- it looks something like this:

SELECT [Zip].[Number]
FROM Zip LEFT JOIN 214 ON [Zip].[Number] = [214].[Number]
WHERE ([214].[Number] Is Null);

Thanks again.
Robert