• 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