Mike,
>Actually, it's incorrect. You can have more than 10 tables per query if you join them using WHERE clause instead of JOIN.
This is one of those "just because you can do it doesn't mean that you should" statements. 10 or more tables in a query is asking for maintenence headaches and performance problems. This sort of problem needs to broken into a couple of other queries that get combined by another query.