Courses / SQL
9. INNER JOIN
A type of join that returns rows when there is a match in both tables.
1 min read Chapter 9 of 29
SQL
INNER JOIN
An INNER JOIN combines rows from two tables when there's a match in both.
"I need to see which customers made purchases, but only those who actually bought something."
An INNER JOIN returns records that have matching values in both tables involved in the join. It filters out records that do not have corresponding matches.
"I need to see which customers made purchases, but only those who actually bought something."
An INNER JOIN returns records that have matching values in both tables involved in the join. It filters out records that do not have corresponding matches.