i'm making inventory DB, to track product transaction and see balance in multiple warehouses.
i have 3 table:
TB1 (warehouses): wharehouse_id .... with: wh1, wh2, wh3 etc...
TB2: (Products) Product_id .... with: A, B, C, D etc...
TB3: (Transactions): Transaction_id. warehouse_id_sender, warehouse_id_reciever. Product_id, quantity
what i want to do is:
make report to see for example:
wh1 productA Sum_quantity
wh1 productB Sum_quantity
wh2 productA Sum_quantity
wh2 productB Sum_quantity