这里是定义,但有问题的主要是用于from(join)的时候,实际用下来,T-Sql是支持的(Sybase有条件支持),而P/L sql似乎不支持(据说oracle 10支持,但是个bug),StackOverflow有人讨论,还有这个连接也是。
而MySql,现在属于Oracle,也官方说明不支持。
Subqueries in the FROM clause cannot be correlated subqueries. They are materialized (executed to produce a result set) before evaluating the outer query, so they cannot be evaluated per row of the outer query.