Join 
A join is an SQL statement that links multiple tables with each other. A join table is created as a result.
More Information
SQL Tutorial, Joins: Information From Several Tables
SQL Reference Manual, JOIN Predicate
Concepts of the Database System, Joins