What happens when an item has multiple matches in the other table?

It appears in the results once for each matchIt appears only once in the resultsIt doesn't appear in the results

It appears in the results once for each match.