There is another link on this topic that may be of interest:

http://www.bennadel.com/blog/70-SQL-Query-Order-of-Operations.htm