Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
[1] in 2015 has introduced a method. First, obtains the distinct from the correlated column in the external query. Then, performs left join operation on the value returned by correlated join and the external query based on correlated columns, as shown in the following figure. The condition of not