1       16:22:40  SQL Execute: ORACLE - Select distinct brid00,zyh000,xm0000,XB0000,FBBH00 From VW_BQ_BRZH00 Where ZYZHID Not In (select ZYZHID from VW_BQ_BRZH00 where CYRQ00  is null) And TO_Number(CYRQ00)>=To_Number('20160622') And TO_Number(CYRQ00)<=To_Number('20160720') And DQBQ00 = 69  and (DQKS00=43 or 0=43)  and brid00 in (select brid00 from zy_brxxb0 where ZYH000='160338')