Getting Started › Left Outer Joins › Order of Predicate Evaluation › NULL Indicator Variables
When selecting a NOT NULL column that could be set to the null value by an outer join, you must supply a host indicator variable for the column.