select a.zyghid,
       a.yjdjh0,
       a.bjrq00,
       a.bjsj00,
       a.zy0000,
       a.requid TXM000,
       b.zyhghh,
       b.zlxmjc,
       b.kdysxm,
       (select bmmc00 from bm_bmbm00 where bmbh00 = b.kdksbh) kdksmc,
       b.kdrq00,
       b.kdsj00,
       c.xm0000
  FRom JY_WJZTX0 a, YJ_YW0000 b, zy_brxxb0 c
 where a.yjdjh0 = b.yjdjh0
   and a.zyghid = c.zyid00
   and a.mzzybz = '1'
   and b.kdksbh = 487
   and a.BJRQ00 >= '20180905'
   and a.BJRQ00 <= '20181029';