>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.
LEFT JOIN tables with names to the main table and use NVL() to pick name from the right table.
--sb--