SQL$HELP72.HLB  —  Select Expressions, Arguments  FROM joined table
    A joined table represents a join between two table references
    specified in the FROM clause.

    There are two types of joined tables:

    o  Qualified join-syntax contains either an implicit or explicit
       predicate

    o  Cross join-syntax does not contain a predicate

    A table can be joined to itself or joined to other tables. When
    an outer join is specified in the joined-table expression, you
    can use the parentheses to explicitly define the join order.
    If only inner or cross joins are specified in the joined-table
    expression, the use of parentheses does not affect the join
    order. SQL tries all possible join orders to find the most
    efficient order for the query. If outer joins are specified in
    the joined-table expression, the join order is determined first
    by any existing parentheses and then by the left-to-right rule.

    The table or correlation names specified in the joined-table
    expression can be referenced by the outer select expression.
Close Help