For information on using WHERE clauses with ON clauses, see “Coding ON Clauses With WHERE Clauses for Outer Joins” on page 259.
For guidelines on using ON and WHERE clauses with outer joins, see “Rules for Coding ON and WHERE Clauses for Outer Joins” on page 262.