Re: can u explain a self join statement in SQL?

On Tue, 25 Oct 2005 22:22:56 -0700, Oraclegroups wrote:

> 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.........

You should subscribe to the beginner's list and ask questions like that. See the thread named "Beginners list", opened by me earlier today. They will gladly answer your question, without much fuss.

-- 
http://www.mgogala.com