SELECT ISNULL(dst.dstname, cdr.cdr_dstname) DistName, cdr.cdr_dstname, cdr_dstcode, cdr.FSL_dstid, cdr.FSL_mapPriority, cdr.cdr_dstcompanytype, cdr.cdr_recordId, cdr.cdr_redistAcctFor, CASE WHEN cdr_priority = '*' THEN 'A+' ELSE cdr_priority END as cdr_priority FROM tbl_CDR_Distributors cdr WITH (NOLOCK) LEFT JOIN tbl_DST_Distributors dst WITH (NOLOCK) ON dst.dstid = cdr.FSL_dstid WHERE cdr.ownerId = AND cdr.FSL_TableCode = 'MFR' ORDER BY cdr.FSL_dstid, cdr.FSL_mapPriority DESC SELECT DistName, cdr_dstname, cdr_dstcode, FSL_dstid, FSL_mapPriority, cdr_dstcompanytype, cdr_recordId, cdr_redistAcctFor, cdr_priority FROM qmd_DstMaster WHERE 1=1 AND NOT cdr_dstcompanytype = 'S' AND cdr_dstcompanytype <> 'R' AND cdr_redistAcctFor IN () --->