select * from s_qf q where q.yf not in (select l.yf from s_lf_history l where l.yhid = q.yhid )
与
select * from s_qf q where q.yhid not in (select l.yhid from s_lf_history l where l.yf = q.yf )
的区别
公司强人写的
select t.* from s_qf t where not exists (select t2.yhid from s_lf_history t2 where t2.yhid=t.yhid and t2.yf=t.yf)