update PackagingRecord set Wrapper = (select Wrapper from TousseInstance where id=PackagingRecord.tousseInstance_Id) ,WrapperCode=(select WrapperCode from TousseInstance where id=PackagingRecord.tousseInstance_Id) where Wrapper is null and tousseInstance_Id in (select id from TousseInstance where Wrapper is not null and Wrapper<>'');