How to list values in a column based on two further columns

[Ifor]

SELECT DISTINCT T1.CommonNumber
FROM YourTable T1
WHERE NOT EXISTS
(
	SELECT 1
	FROM YourTable T2
	WHERE T2.CommonNumber = T1.CommonNumber
		AND T1.SCRCareIDInRMSDB = T2.SCRCareID
);