Join
Data & DatabasesAnswering a question that spans two tables.
Matching rows across tables using a key: orders with their customer names attached. Ordinary and fast when the columns involved are indexed, and very slow when they are not.
See also Foreign key, Index, Normalisation