how to subtract the value of one table from another table in sql code example
Example: how to subtract from the value of a table in sql
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2