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!

Equi Join and Inner Join

848974Mar 21 2011 — edited Mar 21 2011
Difference between Equi Join and Inner Join
Are the 2 statements same

Equi Join:
select A.a from A, B where A.a = B.a

Inner Join
select A.a from A Inner Join B on (a)

Are the above 2 statements provides same results ?
If no whats the differnce.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2011
Added on Mar 21 2011
3 comments
7,180 views