That's because the INNER JOIN only keeps matching rows.