I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as if INTERCEPT wasn't there at all Try it yourself CREATE TABLE testnulls (ID INT) INSERT INTO testnulls VALUES (1) INSERT INTO testnulls VALUES (2) INSERT INTO testnulls VALUES (null) CREATE TABLE testjoin ...