下面三表的查詢, 用到了一個數量計算, 需要疊加以后作為結果的條件, 但是參考到了主表的Id, 下面一直報未知欄位
請問大神們有啥解決的辦法嗎. 獲取有能實作相同效果的SQL陳述句uj5u.com熱心網友回復：
SELECT w.*FROM i_quality_control w
WHERE w.inventory_organization_id = 3605376833355776
AND w.status IN (3, 5)
AND w.warehouse_id = 4222032529260544
AND EXISTS
(SELECT d.id
FROM i_quality_control_detail d
WHERE d.quality_control_id = w.id
AND d.passed_qty > 0 AND d.is_inbound = 0)
AND (
select count(*) from (
SELECT qcd.id
FROM i_quality_control_detail qcd
WHERE qcd.quality_control_id = w.id
AND qcd.passed_qty > 0 AND qcd.is_inbound = 1
union
SELECT bg.quality_control_detail_id
FROM i_barcode_generator bg
WHERE bg.quality_control_id = w.id
AND bg.doc_from = 2
union
SELECT up.quality_control_detail_id
FROM i_unqualified_product up
WHERE up.quality_control_id = w.id) as Tmp
)
<>
(SELECT count(*)
FROM i_quality_control_detail d2
WHERE d2.quality_control_id = w.id) order by id LIMIT 10
有沒有大神幫忙看看
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/181291.html
標籤：MySQL