Select one column with same value and check another column's value
I only use T-SQL, but I don't think anything used below is specific to SSMS:

SELECT DISTINCT Cust_ID
FROM Tbl t
WHERE
    Status = 'D'
AND NOT EXISTS (SELECT * FROM Tbl WHERE Status &lt;&gt; 'D' AND Cust_ID = t.Cust_ID)