Using the following query

select *
from table1
left join table2 on table1.name = table2.name

table1 returns 16 rows and table2 returns 35 rows.

I was expecting the above query to return 16 rows because of the left join, but it is returning 35 rows. right join also returns 35 rows

Why is this happening and how do I get it to return 16 rows?

Edit
Report