IB Computer Science Topic A3.3.2: Constructing Queries Between Two Tables in SQL Key Definitions
A3.3.2 Constructing Queries Between Two Tables in SQL Key Definitions
Definition
Join
A join combines rows from two tables into one result by matching values in a column they share, normally a foreign key in one table and the primary key it refers to in the other.