sql - how to best organize the Inner Joins in (select) statement

Question

let's say i have three tables, each one relates to another,

when i need to get a column from each table, does it make difference how to organize the (inner joins)??

Select table1.column1,table2.column2,table3.column2
From table1 
Inner Join table2 on ..... etc
Inner Join table3 on .....

in another words, can i put (table2) after (From )??

Select table1.column1,table2.column2,table3.column2
From table2
Inner Join table1 on ..... etc
Inner Join table3 on .....

Answer 1

For most queries, order does not matter.

• An INNER JOIN is both associative and commutative so table order does not matter
• SQL is declarative. That is, how you define the query is not how the optimiser works it out. It does not do it line by line as you wrote it.

That said...

• OUTER JOINs are neither associative nor commutative
• For complex queries, the optimiser will "best guess" rather than go through all possibilities which "costs" too much. Table order may matter here