The core idea

A join matches rows across tables.

A join combines rows from two tables wherever a condition holds — usually a foreign key matching a primary key. It's how normalized data is stitched back together.