Metnetsky wrote:
> Q: list employee name, job, manager name and salary for those whose salary
> is more than their manager
>
> The quetion may seem kinda dumb, it's for a class and my professor has a
> thing for brain teaser type questions. I attempted doing this with rename
> and a natural join but I can't get the rename to work I think. Any help
> would be much appreciated.
> Thanx
One more version of query you need:
select e.ename, e.job, m.ename as managername, e.salary
from emp as e join emp as m on (e.mgr=m.empno and e.salary>m.salary);
As Rajesh said - for your example data there is no result for such query.
Regards,
Tomasz Myrta