NATURAL JOIN

A join that silently pairs rows on every column the two tables share by name.

In more detail

It is a trap: adding an unrelated column with the same name to either table, such as created_at, changes the join without any error. Name the rule explicitly with ON instead.

Related terms

Taught in

References