>Yet another compliated SPT string. And believe it or not I really try to figure these out myself before bothering anyone on this forum and I really thank everyone for the help.
>
>I have a table with two columns of employee id's. I need a SPT to use these values to find a matching name from again two possible tables. I figured I could do a join but have only done that where I matched one field.

What about

select * from Mytable My inner Join AnotherTable Another on My.FirstID = Another.EmpID
union ;
select * from Mytable My inner Join AnotherTable Another on My.SecondID = Another.EmpID

If you have two tables add two more UNIONS.