What does INNER JOIN return?

Question

Accepted Answer

INNER JOIN is the default join type - if you write JOIN without a qualifier, you get an INNER JOIN. Rows that exist in one table but have no match in the other table are excluded from the result entirely. This is often the right choice when you only care about records that have a relationship on both sides.