This looks like a plain INNER JOIN:
INNER JOIN
select t1.* from table1 t1 inner join table2 t2 on(t1.first_name = t2.first_name and t1.last_name = t2.last_name)
2.1m questions
2.1m answers
60 comments
57.0k users