select * from sf_yybrb h where not exists( SELECT c.ghhbid FROM BM_CKDY00 a,bm_ckbm00 b,sf_ysghhb c where a.dckbh0=b.ckbh00 and a.sckbh0='131' and b.ckbh00=c.ghhzck and c.ghmzsj>=VKSRQ00 and c.ghmzsj<=VXTRQ00 and h.ghhbid=c.ghhbid)