SQL Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help! I am using Access 2000 and I have two tables that both have a
"phone number" field in them. I need to list all the phone numbers in one
table that are NOT in the second table. I pulled out my SQL reference and I
thought that I could do this with the relational EXCEPT operation. It
appears that this is not usable in Access 2000 - is that true? If so, then
HOW can I find the list of phone numbers that are in one table but NOT in the
other???
 
Check out NOT IN or NOT EXISTS.

SELECT [phone_number]
FROM YourTable1
WHERE [phone_number] NOT IN
( SELECT [phone_number]
FROM YourTable2) ;
 
Back
Top