Joins with expressions and or predicates

See “Predicate transformation and factoring to provide additional optimization paths” for description of how the query optimizer handles joins with expressions and or predicates.