Joins

A join links the data from two or more tables. A table can also be joined to itself.

Which records of the tables involved are included in the derived table depends on the join type and any join conditions that exist.

There are two ways of creating a join:

• with a join expression

• without a join expression: in a SELECT expression or SELECT statement using the FROM clause and, if necessary, the WHERE clause.