Please solve this query

[gsreenathreddy]

Hi!


Please solve this query

in employee table in scott user i would like view the details of all the employees (empno, ename )who are working under which manager(mgr) .with his manager name and manager employee id.

[krishhhna]

Hi!


Please solve this query

in employee table in scott user i would like view the details of all the employees (empno, ename )who are working under which manager(mgr) .with his manager name and manager employee id.

Hi,
This is krishna,you can try this one .i think it would be correct

[code=oracle]Select E.empno,E.ename ,M.empno,M.enam e from emp E,emp M where E.mgr=M.empno;[/code]

[debasisdas]

The example in the previous post is self join. the table is joined to itself using two alias for the same table.