|
直接看SQL
select l.* from t_rw_llrwb l
where l.xnxqdm='2016-2017-1'
and not exists (select 1 from t_pk_sjddb jxbdd where jxbdd.jxbid=l.jxbid
and exists (select 1 from t_pk_sjddb dd,t_xk_xkjg xj where dd.xnxqdm='2016-2017-1' and dd.jxbid=xj.jxbid
and xj.xh='2016882884' and f_jw_pk_zcct(jxbdd.skzc,dd.skzc)=1 and dd.skxq=jxbdd.skxq
and f_jw_pk_jcct(jxbdd.ksjc,jxbdd.jsjc,dd.ksjc,dd.jsjc)=1));
|
|