Joined: 14 Oct 2005 Posts: 1187 Location: Bangalore,India
From th FM
A joined-table specifies a result table that is the result of either an inner equi-join or an outer join. The table is derived by applying one of the join-operators: INNER,RIGHT OUTER, LEFT OUTER, or FULL OUTER to its operands. If a join-operator is not specified, INNER is implicit. The order in which a LEFT OUTER JOIN or RIGHT OUTER JOIN is performed can affect the result.