SQL inner vs left - precedence
Posted on 2013-12-20
In MS SQL 2008, I am looking at a sample code like below:
from table1 t1 inner join table2 t2 on t1.id = t2.id
inner join table3 t3 on t1.id = t3.id
left join table4 t4 on t1.id = t4.id
I wanted to understand which join takes precedence:
1. Do all the three inner join execute first and then the resultset is left joined to the last table? In this case, the precedence is by virtue of which join is written first?
2. Inner joins take precedence over left join , regardless of in which order they are submitted?
3. Left join takes precedence over the inner join?