Actually, I figured it out:-D I just needed to add this to my SELECT statement;

SUP.firstname_vc as [Suprvisor First Name],

SUP.lastname_vc as [Suprvisor Last Name]

Since I was getting the name from the firstname_vc, lastname_vc of the same table. Remember, A staff person could be a Supervisor as well.

I then added this join;

inner join ar.staffmaster as SUP on STM.birthcountry_vc = SUP.staffcode_c

And it worked beautifully. Thanks for your reply though. I am a newbie.