A join is an SQL query that links multiple tables with each other. A join table is created as a result.
See also:
SQL Tutorial, Joins: Information from Several Tables
Reference Manual, Join Predicate