joined-table

joined-table

Syntax

table-reference join-type table-reference

ON join-predicate

Semantics

table-reference

is a table-primary or another joined-table.

join-type

is one of the following:

INNER JOIN

LEFT [ OUTER ] JOIN

RIGHT [ OUTER ] JOIN

join-predicate

for an INNER JOIN, an equi-join based on a PRIMARY KEY-FOREIGN KEY constraint relationship between the joined tables.

for an OUTER JOIN: an equi-join based on a PRIMARY KEY-join key relationship between the joined tables that does not involve a FOREIGN KEY constraint.

Notes

A query that uses INNER JOIN syntax in the FROM clause produces the same result set as a query that uses the WHERE clause to state the join-predicate.
The outer table in an OUTER JOIN is the anchor table.
Note to reviewers: "anchor table" may not be the right term. See note in Outer Joins.
Self outer joins are not allowed.