Specifies a search condition on which the join is based. The
    predicate can have columns from the two operands mentioned, or
    have outer references if it is in a subquery.