I'd say it's misleading at best. It should specify that for multiple matches in the right table, the row from the left table is duplicated per matching row in t

I'd say it's misleading at best. It should specify that for multiple matches in the right table, the row from the left table is duplicated per matching row in the right table.