Link to home
Create AccountLog in
Avatar of Rog D
Rog DFlag for United States of America

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of Jeff Darling
Jeff Darling
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rog D

ASKER

Thanks.