Query Missing ID Numbers

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

Guest

I have a customer table which has all customer ID numbers. I have a second table with customer correspondence. They are joined by ID number. I want to run a query to return all the ID numbers that are in the Customer table but not in the correspondence table. Thanks
 
SELECT CustomerTable.CustomerID, CustomerCorr.CustomerID
FROM CustomerTable LEFT JOIN Payments ON CustomerTable.CustomerID=
CustomerCorr.CustomerID
WHERE (((CustomerCorr.CustomerID) Is Null));

I have a customer table which has all customer ID numbers. I have a second table with customer correspondence.
Click to expand...

They are joined by ID number. I want to run a query to return all the
ID numbers that are in the

Customer table but not in the correspondence table. Thanks
 
Back
Top