Join

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

• SQL Tutorial, Joins: Information From Several Tables

• SQL Reference Manual, JOIN Predicate

• SQL Optimizer, Search Conditions for Joins