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?