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
- join — Combining rows from two tables into one result by pairing rows according to a rule, usually matching keys.
- LEFT JOIN — A join that keeps every row of the left table and adds the matching right-hand rows, or NULLs when there is no match.
- ON clause — The part of a join that states which rows of the two tables belong together.
Taught in
- Inner Joins And Table Aliases — PostgreSQL, Indexing & Relational Data Modeling
- What An Outer Join Really Returns — PostgreSQL, Indexing & Relational Data Modeling