Update BS_Storage set StoreQty = StoreQty-a.mQty from( select NB_DisBill.companyId,goodsId,NB_DisBill.OutStoreId,OutStorePos,mQty, NB_DisBill.billNo from NB_DisBill innerjoin NB_DisBillDetail on NB_DisBill.companyId = NB_DisBillDetail.companyId and NB_DisBill.billNo = NB_DisBillDetail.billNo ) as a where a.companyId = BS_Storage.companyId and a.goodsId = BS_Storage.goodsId and a.OutStoreId = BS_Storage.StoreId and a.OutStorePos = BS_Storage.StorePos and a.billNo ='DB0706200024'and a.companyid ='002'
Update BS_Storage set StoreQty = StoreQty-a.mQty from( select NB_DisBill.companyId,goodsId,NB_DisBill.OutStoreId,OutStorePos,mQty,NB_DisBill.billNo from NB_DisBill inner join NB_DisBillDetail o