select companyname as partnername from tbl_opr_clientoperators with (nolock) where ownerid = and fsltablecode = and operatorid = select cdr_dstname as partnerName from tbl_cdr_distributors with (nolock) where ownerid = and fsl_tablecode = and cdr_recordid =