Home » SQL & PL/SQL » SQL & PL/SQL » Difference between self join and natural join  () 1 Vote
Difference between self join and natural join [message #342641] Sat, 23 August 2008 09:02 Go to next message
gnvsn
Messages: 1
Registered: August 2008
Junior Member
I am new to PL/SQL, Can I know what is the difference between Self Join and Natural Join.

Thanks,
Satyanarayana
Re: Difference between self join and natural join [message #342643 is a reply to message #342641] Sat, 23 August 2008 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


Are you incapable or unwilling to Read the Fine Manuals found at http://tahiti.oracle.com?

Why should we waste our time (re)posting what is already documented by Oracle?

http://en.wikipedia.org/wiki/Join_(SQL)

[Updated on: Sat, 23 August 2008 09:36] by Moderator

Report message to a moderator

Re: Difference between self join and natural join [message #342646 is a reply to message #342641] Sat, 23 August 2008 09:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
JOINS

Regards
Michel
Re: Difference between self join and natural join [message #342652 is a reply to message #342641] Sat, 23 August 2008 11:02 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Well, one is a perfectly natural act, required for the propogation of tables and queries and the other one is dirty and should never be used or you'll go blind.
Previous Topic: Table type error
Next Topic: Fetching middle rows from the database
Goto Forum:
  


Current Time: Fri Dec 09 19:17:19 CST 2016

Total time taken to generate the page: 0.16327 seconds