SELECT  swg.warehouse_owner_goods_id,
       (
              SELECT  IFNULL(SUM(scod.order_quantity - scod.processing_quantity - scod.processed_quantity - IFNULL(srod.wait_out_return_quantity,0)),0)
              FROM store_customer_order sco
              INNER JOIN store_customer_order_details scod ON sco.customer_order_id = scod.customer_order_id
              LEFT JOIN store_return_order_details srod
              ON srod.customer_order_details_id = scod.customer_order_details_id AND srod.warehouse_owner_goods_id = swg.warehouse_owner_goods_id
              -- ON srod.customer_order_details_id = scod.customer_order_details_id AND srod.warehouse_owner_goods_id = scod.warehouse_owner_goods_id
              WHERE scod.warehouse_owner_goods_id = swg.warehouse_owner_goods_id
              AND sco.customer_order_status IN (10, 15, 20)
       ) AS soldCount
FROM store_warehouse_owner_goods swg
WHERE (swg.goods_owner_id = 269886917817057280 AND swg.warehouse_owner_goods_id = 269887534304247808); 

以上SQL, SELECT型子查询, 不管是相关子查询还是独立子查询, 在MySQL的8.0.25版本中都可以运行正常.

但是在8.0.18-X-Cluster-1.0.8版本中,独立子查询可以运行,相关子查询运行失败,失败提示如下:
Error Code: 1054. Unknown column 'swg.warehouse_owner_goods_id' in 'on clause'