mssql exclude select statement based on another select statement here not code example
Example: exclude rows sql server
SELECT Name, BirthDate FROM Employee
EXCEPT
SELECT Name, BirthDate FROM Customer
SELECT Name, BirthDate FROM Employee
EXCEPT
SELECT Name, BirthDate FROM Customer