Re: Query Fails - Need Help Figuring it out

[Scott Nemes]

The below will work:

create view EmployeeBoss (empoyee_number, employee_name, employee_salary, boss_name) as select empl.empno, empl.empname, empl.empsalary, IF(ISNULL(mgr.empname), "None", mgr.empname) from emp empl left join emp mgr on empl.bossno = mgr.empno;

I added in extra logic to account for employees with no boss, but you should be able to modify it as needed. =)

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes