Join

Also written: joins, JOIN ... ON

Combining rows from two or more tables that share a key, such as matching each order to its customer, so a query can show names beside numbers.