mysql - 嵌套左连接查询不起作用

Question

我尝试左连接查询，但失败并显示消息:

Unknown column 'seller_product.seller_product_id' in 'on clause'

这是查询:

SELECT sp.seller_product_id FROM seller_product 
LEFT JOIN ( 
         SELECT spov.seller_product_id 
          FROM seller_product_option_value spov 
          WHERE spov.active = 1 
          AND spov.seller_product_id IN (  2567 ) ) AS option_query 
  ON seller_product.seller_product_id = option_query.spov.seller_product_id

Answer 1

您需要为您的表添加别名，请尝试以下操作:

SELECT sp.seller_product_id FROM seller_product sp
LEFT JOIN ( 
         SELECT spov.seller_product_id 
          FROM seller_product_option_value spov 
          WHERE spov.active = 1 
          AND spov.seller_product_id IN (  2567 ) ) AS option_query 
  ON sp.seller_product_id = option_query.spov.seller_product_id