Message-ID: <3E634D73.6010702@klaster.net>
Date: Mon, 03 Mar 2003 13:41:23 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
MIME-Version: 1.0
To: Metnetsky <matt@uberstats.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: HardCORE QUERY HELP!!!
References: <hOednbvBOI8QG_yjXTWcqQ@giganews.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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