insert into SS_ROLE_OPERATION(ROLE_ID,OPERATION_ID) select id,(select id from SS_OPERATION where operationId='SSTS_AuxiliaryInvoice') from SS_ROLES where 1=1 and exists (select id from SS_OPERATION where operationId='SSTS_AuxiliaryInvoice') and id not in (select ROLE_ID from SS_ROLE_OPERATION where OPERATION_ID=((select id from SS_OPERATION where operationId='SSTS_AuxiliaryInvoice')));