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!

difference between inner joins and = joins

user517698Jul 26 2006 — edited Jul 26 2006

Hi All ,

I would like to select is there any performance difference when using the followings for example :

select a.* from tbl1 A inner join tblB on A.col1 = B.col1 and A.col2 = B.col2

and

select a.* from tbl1 A , tbl2 B where A.col1 = B.col1 and A.col2 = B.col2

appreciate ur advise

tks & rdgs

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2006

Added on Jul 26 2006

4 comments

222 views