Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the difference between equi joins, natural joins and inner joins....

2625117Mar 5 2014 — edited Mar 7 2014

Hi iam confused with these joins mostly... some may telling that there is no difference and some telling that there is difference.. and i want discuss this with oracle community..

please tell the difference between these equi joins, natural joins, and inner joins..

with suitable examples.

and also please explain anti joins and semi joins

Thanking you..

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2014
Added on Mar 5 2014
15 comments
11,897 views