insert into CssdHandleTousses (orgUnitCode, orgUnitName, taskGroup, tousseDefinitionId, tousseName, spelling, wbCode) select ou.orgUnitCoding, ou.name, td.taskGroup, td.id, td.name, td.spelling, td.wbCode from TousseDefinition td join OrgUnit ou on td.handlerDepartCode = ou.orgUnitCoding where td.tousseType = '外部代理灭菌' and td.id not in (select tousseDefinitionId from CssdHandleTousses);