I have two tables:
Each table has a customer id. How do I show New customers who are not also old customers? That is I want to take the Customers_New table and subtract out the Customers_Old. I tried a few different types of joins but none of them seemed to be doing anything that I expected.
I'm using SQl server 2000.