Hi All,
I have a question on joining more than 2 tables.
When we have more than 2 tables to join what is the order of execution :
For eg :
select ...
from table t1 inner join table t2
on t1.a = t2.a
inner join table t3
on t2.b = t3.b
I think it should join t1 & t2 first and then t2 & t3 to further filter the records from the join of t1 &t2.
And if the query is like
select ...
from table t1 inner join table t2
on t1.a = t2.a
inner join table t3
on t1.b = t3.b
Here how it goes? First join First, which i think but just want to confirm.
Thanks.
Sunny