Re: explain self join ?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 29 Oct 2005 10:40:58 +0200
Message-ID: <4363359a$0$25872$636a15ce@news.free.fr>

"Oraclegroups" <sankar_battula_at_yahoo.co.in> a écrit dans le message de news: 1130574497.644560.260270_at_g49g2000cwa.googlegroups.com...
| Hi!
| I have a table with the table name EMP with 3 columns
| empid,empname,managerid.
| How can i get the empname and managername by using the above table
| information?
| Can u please explain it?
| Ok thank you.........

|

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/queries7.htm#2054046 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_103a.htm#2066653

Regards
Michel Cadot Received on Sat Oct 29 2005 - 03:40:58 CDT