What happens when a row from one table matches multiple rows in the other?

The row will appear multiple times in the result table, once for each match.