Assume my database has 3 tables:
Inventory
Sales
Receipts
Inventory has product ID
Sales has product ID and quantity going out
Receipts has product ID and quantity coming in
How do I show ending inventory (summed by product ID)? The ending inventory = quantity coming in - quantity going out.