Joining multiple table - table order

[peterjc]

Hi,

 

Example from mysql.com

 

SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id
  LEFT JOIN table3 ON table2.id=table3.id;

 

SELECT * FROM table1 LEFT JOIN table2 ON table2.id= table1.id

  LEFT JOIN table3 ON table2.id=table3.id;

 

 

So is it the same to write table1.id=table2.id or table2.id= table1.id

 

 

Another example:

 

SELECT * FROM table1 t1, table2 t2 WHERE t1.idtable1=t2.idtable1

 

SELECT * FROM table1 t1, table2 t2 WHERE t2.idtable1=t1.idtable1

 

 

Thanks

[trq]

It makes no difference.