info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
can u explain a self join statement in SQL?
0 views
Skip to first unread message
Oraclegroups
Oct 26, 2005, 1:22:56 AM10/26/05
to
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.........
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.........
DA Morgan
Oct 26, 2005, 1:43:35 AM10/26/05
to
You ask your instructor for extra time after class.
--
Daniel A. Morgan
http://www.psoug.org
damo...@x.washington.edu
(replace x with u to respond)
Mark D Powell
Oct 26, 2005, 11:02:10 AM10/26/05
to
Pull the SQL manual for the version of Oracle that you are using.
Oracle explains what a self-join is there and includes at least one
example.
Oracle explains what a self-join is there and includes at least one
example.
"A self join is a join of a table to itself. This table appears twice
in the FROM clause and is followed by ..."
But your text should have an example.
HTH -- Mark D Powell --
Mladen Gogala
Oct 28, 2005, 7:40:11 PM10/28/05
to
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.
0 new messages