Join

A join is an SQL statement that links multiple tables with each other. A join table is created as a result.

See also:

Concepts of the Database System, Joins

SQL Tutorial, Joins: Information from Several Tables

SQL Reference Manual, Join Predicate