Re: HardCORE QUERY HELP!!!

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