Query Missing ID Numbers

[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

 

[Rover]

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.

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