Consistent relationships are needed when performing multiple joins

Is there a difference in results or a difference in performance between these two statements / examples:

Example 1 (serial relationship INNER)

    SELECT ID FROM TABLE T
    INNER JOIN TABLE2 T2 ON T.ID = T2.ID
    INNER JOIN TABLE3 T3 ON T2.ID = T3.ID

Example 2 (Continuous INNER Relationship)

    SELECT ID FROM TABLE T
    INNER JOIN TABLE2 T2 ON T.ID = T2.ID
    INNER JOIN TABLE3 T3 ON T.ID = T3.ID

or between these two statements / examples:

Example 1 (sequential LEFT relationship)

    SELECT ID FROM TABLE T
    INNER JOIN TABLE2 T2 ON T.ID = T2.ID
    LEFT JOIN TABLE3 T3 ON T2.ID = T3.ID

Example 2 (Inappropriate LEFT ratio)

    SELECT ID FROM TABLE T
    INNER JOIN TABLE2 T2 ON T.ID = T2.ID
    LEFT JOIN TABLE3 T3 ON T.ID = T3.ID

The only difference is that the second Joinis on Table, while the first example is on Table2. I'm sure they will return the same, but I'm just looking for more experienced answers here. Thank.

+3
source share
1 answer

. .

, .

, , , . SQL2008 , ( , ), , .

+3

All Articles