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.