Emp_ID First Name Last Name Manager ID 01 Anderson Dooly (null) 02 Logan Masterson 01 ...
From the last statement, I mean that the manager_id for Logan Masterson is 01, which would mean Anderson Dooly is his manager.
This is my code so far:
select e.employee_id, e.first_name, e.last_name, e.manager_id from f_emp e;
Which pops out a similar table to the one listed above. I'm trying to figure out how to get the name of the manager in that slot instead of the manager's employee number. We've just started the chapter about inner/outer joins, but I cannot figure out how to do this from the books text, or know if I'm going in the right direction. Any guidance would be appreciated.
Also, I'm at work and cannot work on this here. I am using what I can remember from my code to try to give a good enough example to get me pointed where I need to go.
This post has been edited by aj_lavaca: 10 September 2012 - 01:07 AM