inner join

Short definition from Wiktionary

Noun

A join yielding a set of records that combines only the matching records from a set of tables.

We haven’t written up inner join yet: Simple and Standard meanings, examples and a quiz.