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!

Difference in using Inner Join and Equi Join

432292Sep 4 2008 — edited Sep 4 2008
What is the difference in using
an Inner Join as compared to an Equi-Join?

If I need to join three tables using inner join
select t.trade_id from trade t 
     inner join product p 
     on t.product_id = p.product_id 
         inner join trade_key k 
            on t.trade_id = k.trade_id 
            where t.trade_status in('OVER') 
            and p.product_type in ('Bond') 
Now I am using equi-join for the above:
select t.trade_id from trade t,product p,trade_key k
where t.product_id = p.product_id 
and t.trade_id = k.trade_id 
and t.trade_status in('OVER') 
and p.product_type in ('Bond') 
Arent both using inner and equi joins give the same result?

So when do we decide to use which?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2008
Added on Sep 4 2008
2 comments
474 views