TABLE - X (ITEM, QTY)
TABLE - Y (ITEM, QTY)
Please write a Join Query, which sum all items in both the table.
Expected result is as below
TABLE-X ---------- TABLE-Y---------- JOIN OUTPUT
ITEM QTY A ITEM QTY --------------
ITEM QTY
A 10 A 10 A 45
A 15 A 10 B 20
B 20 D 20 C 30
C 30 D 20