The maximum number of tables that can be referenced in a single
join is 61. This includes a join handled by merging derived
tables (subqueries) and views in the
clause into the outer query block (see
Section 126.96.36.199.3, “Optimizing Derived Tables and View References”). It also applies
to the number of tables that can be referenced in the definition
of a view.