select a.item, sum(a.qoh) A_QOH, sum(b.qoh) B_QOH from tbl_a a join tbl_b b on a.item = b.item having sum(a.qoh) != sum(b.qoh)
Select allOpen in new window
SELECT item, SUM(QOH) FROM tableA GROUP BY item UNION SELECT item, SUM(QOH) FROM TableB GROUP BY item
Open in new window