title: Why do I still get duplicates on [CONMAT_MATCHING_DONOR] even after using DISTINCT?
body: <p>I still get duplicates on [CONMAT_MATCHING_DONOR] even after using <code>DISTINCT</code>.  </p>
  
  <pre><code>SELECT TOP 1000 [CONTRIB_MATCH_ID]
            ,[CONMAT_CONTRIBUTION]
            ,[CONMAT_FORM_RECEIVED_DATE]
            ,[CONMAT_MATCHING_DONOR]
            ,[CONMAT_STATUS]
            ,[STATUS_DESC]
            ,[CONMAT_STATUS_DATE]
        FROM [ods_production].[dbo].[SPT_CONTRIB_MATCH]
        WHERE  [CONMAT_MATCHING_DONOR] IN  (SELECT  DISTINCT   
              [CONMAT_MATCHING_DONOR]
              FROM [ods_production].[dbo].[SPT_CONTRIB_MATCH])
       ORDER BY [CONMAT_MATCHING_DONOR] DESC 
  </code></pre>