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.