<div>
try this<br />

<pre><code id="code-31048">SELECT tableA.* FROM tableA LEFT JOIN tableB ON (tableA.CardNumber=tableB.CardNumber AND tableA.Profile=tableB.Profile) WHERE
(tableB.CardNumber IS NULL OR tableB.Profile IS NULL)
</code></pre>
</div>


try this


SELECT tableA.* FROM tableA LEFT JOIN tableB ON (tableA.CardNumber=tableB.CardNumber AND tableA.Profile=tableB.Profile) WHERE
(tableB.CardNumber IS NULL OR tableB.Profile IS NULL)


<div>
<div class="content wysiwyg-content">
I have the following table A, together the 2 columns make a key:<br />
CardNumber<br />
Profile<br />
<br />
Then I have table B which is a subset of table A same columns.<br />
<br />
How can I get the values which are in table A which are not in table B? &nbsp;I need all the card/profile combinations in A which are not in B.<br />
<br />
Thanks
</div>
</div>


I have the following table A, together the 2 columns make a key:
CardNumber
Profile

Then I have table B which is a subset of table A same columns.

How can I get the values which are in table A which are not in table B?  I need all the card/profile combinations in A which are not in B.

Thanks

Query Question

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.