Answer:
An inner join.
Inner join combines matching rows from 2 tables at one time, so that is the reason I chose this join.
8.3m questions
10.9m answers