Left outer join

In all cases, the order of evaluation is as follows:

1. Evaluate all filters in the ON clause.
2. Add in rows from the outer table (in this case, the left table in the left outer join) that do not match the filters.
3. Apply the where clause to the results of the outer join.