<div>
<div class="content wysiwyg-content">
I two tables with Item_no and QOH in them.<br />
<br />
Table A<br />
Item &nbsp; &nbsp; &nbsp; QOH<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7<br />
789 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<br />
<br />
Table B<br />
Item &nbsp; &nbsp; &nbsp; QOH<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4<br />
789 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28<br />
<br />
<br />
Result Set<br />
Item &nbsp; &nbsp;QOH &nbsp;QOH<br />
456 &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4<br />
789 &nbsp; &nbsp; 30 &nbsp; &nbsp; &nbsp; &nbsp; 28
</div>
</div>


I two tables with Item_no and QOH in them.

Table A
Item       QOH
123         50
456           7
789          30

Table B
Item       QOH
123         50
456          4
789          28


Result Set
Item    QOH  QOH
456     7            4
789     30         28

SQL - Show rows in two tables where sums are not equal.

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.