Outer query table ref support

from the Artful MySQL Tips List

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 LATERAL keyword is added, MySQL also searches the FROM clause containing the derived table.

SQL standard SQL92 and since have supported these capabilities. Details: here.

Last updated 26 Nov 2019

Return to the Artful MySQL Tips page