sql - How to search for multiple names on different rows where first name and last name on different columns?

Question

ID	FIRST_NAME	LAST_NAME
1	SARA	JAMES
5	STEVE	STEPHEN
2	KAL	LEE
33	TONY	KAMPLOO
3	SANDRA	BROWN
23	HOPE	WHITE

Answer 1

This looks like a plain 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)