SELECT * FROM raw_stk WHERE NOT exists (SELECT 1 FROM stk_mst_raw where raw_stk.item_num=stk_mst_raw.item_num_old);
语句1: select * from raw_stk minus select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old; 语句2: select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old;
当然差别大啦,用in时找到就可以进行下一个,而用 not in时需要遍历全部后才能进行下一个
select * from raw_stk minus select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old;同意这个!
WHERE NOT exists (SELECT 1 FROM stk_mst_raw
where raw_stk.item_num=stk_mst_raw.item_num_old);
select * from raw_stk
minus
select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old;
语句2:
select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old;
minus
select a.* from raw_stk a,stk_mst_raw b where a.item_num=b.item_num_old;同意这个!