Supporting all kinds of outer references in derived tables (lateral, or not)
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.… Facebook Twitter Google+ LinkedIn Source: Supporting all kinds of outer references in derived tables (lateral, or not)