select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,
XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,CXSL00,
DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,
KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,
APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,
ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,
YPNM00,JGZCBZ,DCBZ00,TQPC00,CXDJH0,ZJE000,YJLRBZ,
BZ0000,KDBQ00,CH0000,NL0000,BQSFBZ,
(select czyxm0 from zy_brfy00 m where b.sfdjh0=m.djh000) czyxm0  from yj_yw0000 b
where xmzt00 not in('7') and ZYHGHH=007309
 and yjlrbz='N' 
 and kdksbh  in (select  ksh000 from bm_bqks00 where bqh000=51) 
 and zlxmid<>0 
 and  xmzt00<>'6' and SL0000-nvl(CXSL00,0)>0
 and  (not  exists  ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 AND a.zyhghh=b.zyhghh AND A.SL0000=nvl(B.CXSL00,0))) 
  or ZLXMID in (Select ZLXMID FROM BQ_HZYZXMST ) )
 and kdrq00 between '20010809' and  '20010809'
 order by yjdjh0