I never run out of SPT challenges!

I have one table of data which one of the columns has an employee id. The employee name can be in one of two tables depending on wheather they are direct hire or contractor. I need one SPT that gets the employeeid from my table then matches their name in the other two tables.