xxxxxxxxxx
The SQL MINUS operator is used to return
all rows in the first SELECT statement
that are not returned by the second SELECT statement.
Each SELECT statement will define a dataset.
]The MINUS operator will retrieve all records
from the first dataset and then remove from
the results all records from the second dataset.
xxxxxxxxxx
EXCEPT
EXCEPT is the sql server equivalent of the MINUS operator
sql server has also the INTERSECT operator you can guess what it does ;)
xxxxxxxxxx
(SELECT f_name, l_name, position FROM Yankees1
MINUS
SELECT firstName, lastName, Positions FROM Yankees2)