Question

If you want to join all of the rows in the first table of a SELECT statement with just the matched rows in a second table, you use what kind of join

Answer 1

An inner join.

Inner join combines matching rows from 2 tables at one time, so that is the reason I chose this join.