Join order won't define execution order most of the times. My suggestion is that you write your JOINs in a logical order that would make easier for developers to read and modify.
I would clarify that this is true only when all of the joins are INNER or CROSS joins. Once you add OUTER joins, the order definitely does make a difference.
Drew
And my advice would still be to write it on the most logical way possible.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2