WITH VALS AS (SELECT DISTINCT C2ALIAS FROM MHGROUP.DOCMASTER WITH (nolock))
SELECT C2.C_DESCRIPT AS MatterNum
FROM VALS LEFT JOIN MHGROUP.CUSTOM2 C2 ON VALS.C2ALIAS = C2.CUSTOM_ALIAS