grawsha2000@yahoo.com (al) wrote:

>EmployeeID Title ReportsTo FirstName SecondName ......
>.....
> 1 Manager 4 Steven Buchan
> 2 Sale Rep. 1 Janet Leverling
> 3 Clerk 1 Ropert King
> 4 Presedint Null Andrew Fuller
>
>My question is how can I get the column ReportsTo to include first and
>second name, instead of numbers (employeeid).
>
>What I want is something like this(firsname, lastname OR lastname,
>firstname for the ReportsTo columen):
>
>EmployeeID Title ReportsTo FirstName SecondName
>... ...
> 1 Manager Andrew Fuller Steven Buchan
> 2 Sale Rep. Steven Buchan Janet Leverling
> 3 Clerk Steven Buchan Ropert King
> 4 Presedint Null Andrew Fuller
>
>MTIA,
>Grawsha

Try:
select t.employeeID, t.title, r.firstname+' '+r.lastname as 'Boss',
t.firstname, t.lastname
from testjoin t left outer join testjoin r
on t.reportsto = r.employeeID
order by t.employeeID

HTH,
Myron