Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
distinct join here corresponds to <=> in MySQL. The result of null <=> null is true, so the returned value and the external query can be joined together. For the preceding example, as shown in the following figure, perform distinct operation on the correlated column partkey of external query first.