2014年10月27日

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)