OraFAQ Forum: SQL & PL/SQL » Difference between self join and natural join

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between self join and natural join (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between self join and natural join [message #342641]

Sat, 23 August 2008 09:02

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

Report message to a moderator

Re: Difference between self join and natural join [message #342643 is a reply to message #342641]

Sat, 23 August 2008 09:08

BlackSwan
Messages: 26766
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

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

JOINS

Regards
Michel

Report message to a moderator

Re: Difference between self join and natural join [message #342652 is a reply to message #342641]

Sat, 23 August 2008 11:02

pablolee
Messages: 2882
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.

Report message to a moderator

Previous Topic:	Table type error
Next Topic:	Fetching middle rows from the database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 00:17:52 CDT 2025