SELECT kp_item_no FROM pf_dj_detail b
WHERE NOT EXISTS(SELECT 1 FROM jb_spzl a WHERE a.kp_item_no=b.kp_item_no)
sql not exists取代 in
最新推荐文章于 2024-03-19 14:35:04 发布
SELECT kp_item_no FROM pf_dj_detail b
WHERE NOT EXISTS(SELECT 1 FROM jb_spzl a WHERE a.kp_item_no=b.kp_item_no)