select ownerid, fsltablecode as ownertype, companyname as partnername, operatorid as partnerid, 'OPR'+ CAST(operatorid as varchar) + ' ' + companyname as subjectDescription from tbl_opr_clientoperators where operatorid = select ownerid, fsl_tablecode as ownertype, cdr_dstname as partnername, cdr_recordid as partnerid, 'CDR'+ CAST(cdr_recordid as varchar) + ' ' + cdr_dstname as subjectDescription from tbl_CDR_Distributors where cdr_recordid =