教务查询学生时间不冲突的教学班

zpwu

直接看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));