I think this one will work Select a.ename as Employee ,b.ename as Manager

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example
empno ename mgr_id
1 john 3
2 paul 3
3 smith 1
4 kevin 1
5 stewart 2

result has to look like this

ename manager
john smith
paul smith
smith john
kevin john
stewart paul

can u plz help me out in this.....

Question Posted / praveen h

8 Answers
11930 Views
I also Faced
E-Mail Answers

Answer Posted / praveen h

I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno

Is This Answer Correct ?

9 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are procedures used for?

924

What is example of database?

988

Does pl sql work in mysql?

923

What are functions in sql?

906

How do I run a query in pl sql developer?

929

What are sql commands?

938

what is the difference between char_length and length? : Sql dba

993

What is a full join?

912

explain the difference between delete , truncate and drop commands? : Sql dba

1020

Explain how can you save or place your msg in a table?

985

How do I sort a table in sql?

983

how to select first 5 records from a table? : Sql dba

922

Which is better stored procedure or query?

922

What is the difference between inner join and natural join?

956

What is sql in oracle?

1004