<div>
I may have stumbled on it. Is this it: <br />
<br />
select * from customers_new<br />
inner join customers_old on customers_new.customerid = customer_old.customerid
</div>


I may have stumbled on it. Is this it:

select * from customers_new
inner join customers_old on customers_new.customerid = customer_old.customerid

<div>
<div class="content wysiwyg-content">
I have two tables:<br />
<br />
Customers_New<br />
<br />
Customers_Old<br />
<br />
Each table has a customer id. &nbsp;How do I show New customers who are not also old customers? &nbsp;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.<br />
<br />
I'm using SQl server 2000.
</div>
</div>


I have two tables:

Customers_New

Customers_Old

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.

How to subtract the results of one table from another in sql?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.