update TousseItem set isTraceable=( select td.isTraceable from TousseDefinition td where td.id=TousseItem.tousseDefinitionId ) where tousseDefinitionId is not null;