outer join

Short definition from Wiktionary

Noun

A join yielding a set of records that combines every record from a set of tables.

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