inner join

A join that keeps only the pairs of rows that satisfy the ON rule, dropping rows with no match on either side.

In more detail

A plain JOIN is an inner join. Because unmatched rows vanish silently, a customer with no orders simply does not appear, which is correct for some questions and a bug for others.

Related terms

Taught in

References