Itzik Ben-Gan saves the day once again!

I was bothered that the join clause for the right table of a left outer join was being ignored. Little did I know...

There are three logical steps to a join:

1. cartesian product

2. ON filter

3. Add Outer rows

The physical steps must produce the output that the logical steps would produce. Specifically, the right table filter on the left outer join was not being ignored in this article...the outer rows were being added back in on step 3.