Views Used with Outer Joins

If you define a view with an outer join, then query the view with a qualification on a column from the inner table of the outer join, the results may not be what you expect. The query returns all rows from the inner table.

Rows that do not meet the qualification show a null value in the appropriate columns of those rows.

The following rules determine the types of updates you can make to columns through join views: