<div>
This works in Oracle, I think you can change it if neccessary to &nbsp;MS-SQL:<br />
<br />
Select X from B<br />
MINUS<br />
Select X from A;
</div>


This works in Oracle, I think you can change it if neccessary to  MS-SQL:

Select X from B
MINUS
Select X from A;

<div>
You can ask 0-point question in a Community Support for refunding points :)
</div>


You can ask 0-point question in a Community Support for refunding points :)

<div>
This question has been answered by the asker.<br />
<br />
mlmcc<br />
DB Reporting Tools PE
</div>


This question has been answered by the asker.

mlmcc
DB Reporting Tools PE

<div>
<div class="content wysiwyg-content">
I am using MS-SQL Query Analyser.<br />
<br />
I have two tables (&quot;A&quot; &amp;&nbsp;&quot;B&quot;) that both have a column named &quot;X&quot;. &nbsp;Both columns contain the same type of information. &nbsp;There are some differences betwen the contents of the 2 columns.<br />
<br />
In particular, Table A col X contains a list of approx 100000 distinct numbers. &nbsp;Table B col X contains approx 1 million numbers (not distinct).<br />
<br />
I need to find out which numbers in table B col X do not exist in table A col X. &nbsp;Help please!!!!!! &nbsp;Thank you!
</div>
</div>


I am using MS-SQL Query Analyser.

I have two tables ("A" & "B") that both have a column named "X".  Both columns contain the same type of information.  There are some differences betwen the contents of the 2 columns.

In particular, Table A col X contains a list of approx 100000 distinct numbers.  Table B col X contains approx 1 million numbers (not distinct).

I need to find out which numbers in table B col X do not exist in table A col X.  Help please!!!!!!  Thank you!

Compare two columns in different tables and extract difference between them

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.