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 188.8.131.52.3, “Optimizing Derived Tables and Views in the FROM Clause”). It also
applies to the number of tables that can be referenced in the
definition of a view.