Please test Query SQL:

SELECT DISTINCT A.Status

FROM dbo.Test1 A

LEFT JOIN dbo.Test2 B

ON A.Status= B.Status

WHERE A.Status IS NOT NULL

AND B.Status IS NULL

Because of Number of rows in dbo.Test1 A more than...