select b.cdr_recordId bDistributorId, b.cdr_dstcode bDistributorNbr, b.cdr_dstName bDistributorName, d.cdr_dstcode DistributorNbr, d.cdr_dstName DistributorName, d.cdr_recordId distributorId from tbl_CDR_Distributors b inner join tbl_CDR_Distributors d on d.ownerId = b.ownerId and d.fsl_tablecode = b.fsl_tablecode and d.cdr_dstcode = left( b.cdr_dstcode, len( b.cdr_dstcode ) -1 ) where b.cdr_dstcode like '%B' and b.ownerId = 26 and b.fsl_tablecode = 'MFR'