13.2.10.7 Correlated Subqueries - MySQL

A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 ...

dev.mysql.com