Update MATERIAL_IN A Set A.STORECOUNT = (select A.STORECOUNT - C.Num*(10) from FINPRODUCT_OUT B,Material_waste C Where B.HANDBOOKNO = '20041015013' And B.SERIALNO = '1' And B.INTER_ID=C.PRODUCT_ID And A.HANDBOOKNO = B.HANDBOOKNO And A.SERIALNO = C.MATERIALSEQ')
Update MATERIAL_IN A
Set A.STORECOUNT = (select A.STORECOUNT - C.Num*(10)
from FINPRODUCT_OUT B,Material_waste C
Where B.HANDBOOKNO = '20041015013' And B.SERIALNO = '1'
And B.INTER_ID=C.PRODUCT_ID
And A.HANDBOOKNO = B.HANDBOOKNO And A.SERIALNO = C.MATERIALSEQ')