Library /sys$common/syshlp/SQL$HELP72.HLB  —  Oracle Style Outer Join, Oracle Server Predicate
    The following notes apply when you use the Oracle server
    predicate:

    o  If tables A and B are joined by multiple join conditions, then
       the plus (+) operator must be used in all these conditions.

    o  The plus operator can be applied only to a column, not to an
       arbitrary expression. However, an arbitrary expression can
       contain a column marked with the plus operator.

    o  A condition containing the plus operator cannot be combined
       with another condition using the OR logical operator.

    o  A condition cannot use the IN comparison operator to compare a
       column marked with the plus operator to another expression.

    o  A condition cannot compare a column marked with the plus
       operator to a subquery.

    o  If the WHERE clause contains a condition that compares a
       column from table B to a constant, then the plus operator
       must be applied to the column such that the rows from table A
       for which Oracle Rdb has generated NULLs for this column are
       returned.

    o  In a query that performs outer joins of more than two pairs
       of tables, a single table can only be the null-generated table
       for one other table. For this reason, you cannot apply the
       plus operator to the column of table B in the join condition
       for tables A and B and the join condition for tables B and C.
Close Help