Hi all, I have a table that I enter count of each product every day and the products may enter or exit from our warehouse, now I need a SQL code to return total products that we have in the warehouse, like this :
Result : (total product in the warehouse)
A1 | in | 15 |
A1 | in | 16 |
A1 | out | 5 |
A2 | in | 4 |
A2 | out | 2 |
A3 | in | 10 |
A3 | in | 5 |
Result : (total product in the warehouse)
A1 | 26 |
A2 | 2 |
A3 | 15 |