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