SI NO - Product - Qty 1 Monitor 10 2 Mouse 20 3 Keyboard 15 4 Speaker 10
SI NO - Product - Product Id - Qty 1 Monitor 1 5 2 Mouse 2 8 3 Speaker 4 7
SI NO - Product - Qty 1 Monitor 5 2 Mouse 12 3 Keyboard 15 4 Speaker 3
update work_order a set a.Qty=a.Qty - b.Qty from Bill b where a.SI_NO=b.Product_Id --AND a.Product=b.Product
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)