Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
connecting external queries and subqueries is called CorrelatedJoin, which is also known as lateral join and dependent join. The left subtree is called external query (input), while the right subtree is called subquery. External columns that appear in the subquery are called correlated columns. The