9. Select the employee names and their manager names (keep in mind, one employee works for multiple departments so they will have multiple managers)

[enter image description here][1]

[1]: https://i.stack.imgur.com/4KrLW.jpg**strong text**

Hello, I'm having a very difficult time answering this question. I have tried the below query: SELECT e.ename as employee ,emp.ename as manager FROM Emp e INNER JOIN Works w ON e.eid = w.eid INNER JOIN Dept d ON w.did=d.did INNER JOIN Emp emp ON d.managerid = emp.eid;

this returns: employee manager Parto Bamford Parto Bamford

Is there a way for me to return no values for the manager of Parto Bamford?

https://stackoverflow.com/questions/66978651/9-select-the-employee-names-and-their-manager-names-keep-in-mind-one-employee April 07, 2021 at 10:06AM