update RecyclingDamageItem set handleDepartName = (select o.name from OrgUnit o where o.orgUnitCoding = RecyclingDamageItem.handleDepartCode); update RecyclingError set handleDepartName = (select o.name from OrgUnit o where o.orgUnitCoding = RecyclingError.handleDepartCode);