Dear sir
I have two sql table Table1 and Table2 which have the following data
Table1
ID
ItemName
Quantity
1
Collar
100
2
freeze
200
3
collar
400
4
5
tv
6
500
Table2
70
60
50
90
300
I want to find the difference of Sum of Quantity of both tables. And want to calculate like
Result
370
410
Please help to execute sql query for solving this problem
Thanks advance