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 22.214.171.124, “Optimizing Derived Tables, View References, and Common Table Expressions”). It also applies
to the number of tables that can be referenced in the definition
of a view.