<div>
This query will do it:<br />
<br />
Select EMailCampaign.* From EMailCampaign<br />
Left Join Unsubscribe on EMailCampaign.email = Unsubscribe.Email<br />
WHERE Unsubscribe.Email Is Null
</div>


This query will do it:

Select EMailCampaign.* From EMailCampaign
Left Join Unsubscribe on EMailCampaign.email = Unsubscribe.Email
WHERE Unsubscribe.Email Is Null

<div>
<div class="content wysiwyg-content">
I have been reading about the minus operation, and haven't got it to work yet. &nbsp;This is what i need done, maybe someone can answer it for me.<br />
<br />
Tables:<br />
<br />
Emailcampaign-----Fields are email, name, etc<br />
Unsubscribe-------Fields are email, etc<br />
<br />
I need a query that will return all of the records in<br />
the emailcampaign MINUS any in the unsubscribe table so that we will not mail any emails to people who have unsubscribed.
</div>
</div>


I have been reading about the minus operation, and haven't got it to work yet.  This is what i need done, maybe someone can answer it for me.

Tables:

Emailcampaign-----Fields are email, name, etc
Unsubscribe-------Fields are email, etc

I need a query that will return all of the records in
the emailcampaign MINUS any in the unsubscribe table so that we will not mail any emails to people who have unsubscribed.

Minus

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.