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 | freeze | 200 |
| 5 | tv | 200 |
| 6 | tv | 500 |
Table2
| ID | ItemName | Quantity |
| 1 | Collar | 70 |
| 2 | collar | 60 |
| 3 | tv | 200 |
| 4 | freeze | 50 |
| 5 | tv | 90 |
| 6 | freeze | 300 |
I want to find the difference of Sum of Quantity of both tables. And want to calculate like
Result
| ItemName | Quantity |
| Collar | 370 |
| freeze | 50 |
| tv | 410 |
Please help to execute sql query for solving this problem
Thanks advance