So you want to add the in and subtract the out in a single SQL statement?
Not sure of your schema, but something like this will work
UPDATE Inventory
SET CurrentQty = Inventory.CurrentQty + IsNull(StokIn.QtyIn, 0) - IsNull(StokOut.QtyOut, 0)
FROM Inventory
LEFT JOIN StokIn ON Inventory.MedicineId = StokIn.MedicineId
LEFT JOIN StokOut ON Inventory.MedicineId = StokIn.MedicineId