Re: sql query

I assume you mean:

select employee.empnum, manager.ename
from emp employee, emp manager
where employee.mgrno = manager.empnum (+);

With the outer join added for the President who has no manager.

Divkg wrote:

> Let us say . There is a emp table (empnum,ename,sal,mgrno) as we see usnder
> scott/tiger schema.
> please write the query.
> select all empnum and thier magagers name .
Received on Wed Nov 04 1998 - 19:18:00 CST