select 'M:4441;B:14;O:' + convert( varchar, operatorId ), a.objectId operatorId, skcdr.cdr_dstCode, skcdr.cdr_recordId from tbl_OPR_ClientOperators opr inner join tbl_CDR_Distributors cdr on cdr.cdr_recordId = opr.distrib1 and cdr.cdr_dstcode <> '' inner join tbl_CDR_Distributors skcdr on skcdr.cdr_dstCode = cdr.cdr_dstcode and skcdr.ownerId = 4441 and skcdr.fsl_tablecode = 'MFR' inner join tbl_IMPORT_Aliases a on a.ownerId = skcdr.ownerId and a.ownerType = skcdr.fsl_tablecode and a.objectType = 'OPR' and a.alias = 'M:4441;B:14;O:' + convert( varchar, operatorId ) where opr.ownerId = 14 and opr.fsltablecode = 'BRO' update tbl_OPR_ClientOperators set distrib1 = where operatorId =