|Given an outer query containing a subquery containing in turn a derived table, MySQL since version 8.0.14 allows the derived table definition to refer to tables named in the outer query or the subquery. So ...
1 When parsing a derived table def, MySQL now accepts non-lateral outer references, and
2 If the
SQL standard SQL92 and since have supported these capabilities. Details: here.
Last updated 26 Nov 2019