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