not in 想变成 not exists,发现语义相等了,但是还是得到的数据不一致,在处理null时就出现意外了。
SELECT * from CW_HP_SKR
where khh not in (select yhmc from CW_PJDATA_FKH);
SELECT * from CW_HP_SKR a
WHERE
NOT EXISTS (
not in 想变成 not exists,发现语义相等了,但是还是得到的数据不一致,在处理null时就出现意外了。
SELECT * from CW_HP_SKR
where khh not in (select yhmc from CW_PJDATA_FKH);
SELECT * from CW_HP_SKR a
WHERE
NOT EXISTS (