怎樣找到where 條件不存在的那筆資料
- 2022-10-27
select a。id from
(
select ‘01’ ID FROM dual
UNION ALL
select ‘02’ ID FROM dual
UNION ALL
select ‘03’ ID FROM dual
UNION ALL
select ‘04’ ID FROM dual
) a
WHERE a。id NOT IN
(
SELECT erp_id FROM erp
WHERE erp_id = a。id
)
上面語句查詢不到,說明erp表是沒有id:02的資料了,你可以看看該表關係,看看erp表與哪些表有外來鍵聯絡,可以在那些表裡面找找
select b。*
from (select ‘01’ as erp_id union select ‘02’ union select ‘03’)a
left join erp b on a。erp_id=b。erp_id
再看看別人怎麼說的。
上一篇:書櫃做30cm深夠嗎
下一篇:窗明几淨讀音?