update vs4tinventorylot set timcunitRatioC=(Select abs(tinmamouquantity) from vs4tinventorymb where vs4tinventorymb.tinmtinvno=vs4tinventorylot.timcreceiveno and vs4tinventorymb.tinmln=vs4tinventorylot.timcreceiveln) where vs4tinventorylot.timcunitcalc=0
GO
