Does order matter in a JOIN clause?

Does the order of tables referenced in a JOIN clause affect query performance. In this post, Joe addresses this question by examining the query execution plans created for sample queries.