For INNER JOIN, WHERE predicates and ON predicates have the same effect. For OUTER JOIN, WHERE predicates and ON predicates have a different effect.
