select 
    table1.name as left_name,
    table2.name as right_name
from
    table1
left join
    table2
on
    table1.name=table2.name