Inner join
Also written: INNER JOIN, JOIN
A join that keeps only the pairs of rows that match in both tables. Plain JOIN means the same; unmatched rows, like Tom Reyes with no orders, disappear.
Also written: INNER JOIN, JOIN
A join that keeps only the pairs of rows that match in both tables. Plain JOIN means the same; unmatched rows, like Tom Reyes with no orders, disappear.