What happens when an item has multiple matches in the other table?
It appears in the results once for each match.