Explicit join operations page 4
Commutative & Associative Laws and Joins
Inner and full outer joins are both commutative and associative, i.e. the following is fair for them:
It is obvious that left/right joins are not commutative in view of
But its are associative, for example:
From the practical point of view, associativity means that we might use no brackets defining the treatment order of joins.
However the law of associativity, which is fair for connections of the same type, is being broken when the joins of different types are used in a query. Let's show this on example.
Results of two queries are being separated by blank row for convenience.
Let's notice that in absence of brackets we shall receive the result conterminous with result of the first query, as joins will be carried out in the order that they are written in.