What does INNER JOIN do when rows don't have a matching value in the other table?

It doesn't join them, so they won't appear in the resultsIt joins them to a randomly picked row

It doesn't join them, so they won't appear in the results.