Supporting all kinds of outer references in derived tables (lateral, or not)
(Image credit: Pixabay).
In my earlier post, I showed how MySQL, since version 8.0.14, has support for LATERAL derived tables. With LATERAL, a JOIN can have a second table – a subquery-based derived table – be defined based on values from columns of the first table, and thus be re-calculated for each row of the first table.…
Source: Supporting all kinds of outer references in derived tables (lateral, or not)
