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!

Any differences between inner join and join without any keyword(inner join)

user480768Feb 14 2013 — edited Feb 14 2013
Are there any differences between following two join statements?

Join Statement 1:

select column1, column2 from table1 t1, table2 t2 where t1.t1Key=t2.t2Key;




Join Statement 2:

select column1, column2 from table1 t1 inner join table2 t2 on t1.t1Key = t2.t2Key;


Thanks for your reply.

Kevin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2013
Added on Feb 14 2013
3 comments
744 views