the “left” and “right” query on either side of an INTERSECT/EXCEPT clause

 

EXCEPT and INTERCEPT clauses
EXCEPT and INTERCEPT

One thing I didn’t even notice in the last post was that the SELECT query above the EXCEPT/INTERSECT was referred to as┬áthe query “on the left,” and the one below the EXCEPT/INTERSECT was referred to as “on the right.”

This actually does make sense if you imagine reading these things left to right. However, it sounded like one of those little differences in meaning that could trip a newbie like me up in training. Thankfully the guys who did this one made sure to point out the terminology and what it meant.