select t1.name, t2.name from t1 left outer join t2 on t1.name = t2.name