A join may be performed on two or more tables or subqueries. Join types include INNER JOIN (the equivalent of simply specifying JOIN) and OUTER JOIN (LEFT, RIGHT, or FULL).

A table expression (table name or qualified join specification) can be included in parentheses to specify that it should be evaluated before other table expressions in the SELECT statement.