>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.
You could do a UNION between 2 selects that attempt to match the employee from one table and then the other..
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________