A subquery that references one or more columns from its containing SQL statement is called a correlated subquery.

• (如果一个子查询中引用了包含查询语句的一个或多个字段，则该子查询就称为相关性子查询。