我知道这是一个JOIN问题,但不确定为什么?查询本身运行得很好,但是当我添加第一个SELECT时,我得到了JOIN问题。pdx_sap_user.dbo.vw_po_header H join pdx_sap_user.dbo.vw_po_itemjoin pdx_sap_user.dbo.vw_kd_business_unit K
on M.business_unit_code = K.business_
shop_idshop_id -> id from shop table我想找到可以发往country_id 60的产品SELECT p.*, c.*, p.product_name AS scoreJOIN `rcp_shipping``shop_id` AND s.country_id = 60
JOIN `rcp_category` c ON `c`.`c
SELECT (CASE t1.part IS NULL THEN t2.part ELSE t1.part END) AS partno,FROM t1 LEFT JOIN t3 ON t1.part = t3.part
OR t2.part = t3.partconcat(documents.documentname,': ', inventoryin_document