Greetings,
Would be thankful for your kind help. I have a table (Northwind
employees table). In the employees table, a column called ReportsTo
which lists the EmployeeID, int data type, of the manager of an
employee.This ReportsTo column is basically the EmployeeID column:
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