select A.name, CASE WHEN B.name IS NOT NULL THEN 1 ELSE 0 END from table1 A left join table2 B on A.name = B.name