SELECT a.bh0000,
       a.zyghid,
       a.brxm00,
       a.brxb00,
       a.brnl00,
       a.brkh00,
       a.mzcyrq,
       a.zd0000,
       a.yj0000,
       a.ksbh00,
       a.ksmc00,
       a.zt0000,
        decode(a.kjrq00,null,null,substr(a.kjrq00,1,4)||'年'||substr(a.kjrq00,5,2)||'月'||substr(a.kjrq00,7,2)||'日') kjrq00,
       a.kjys00,
       (SELECT zwxm00
          FROM bm_ygbm00
         WHERE ygbh00 = a.kjys00)
           kjysxm,
       '' ysqm00,
       (SELECT brid00
          FROM zy_brxxb0 b
         WHERE b.zyid00 = a.zyghid AND ROWNUM = 1)
           brid00,
       (SELECT zyh000
          FROM zy_brxxb0 b
         WHERE b.zyid00 = a.zyghid AND ROWNUM = 1)
           zyh000,
       (SELECT yyqc00
          FROM xt_yyxx00
         WHERE yyid00 = '225089')
           yyqc00,
           d.brzjbh,
           nvl(d.brlxdz,d.brjtdz) brlxdz,
           decode(c.sjryrq,null,null,substr(c.sjryrq,1,4)||'年'||substr(c.sjryrq,5,2)||'月'||substr(c.sjryrq,7,2)||'日') ryrq00,
           decode(c.cydjrq,null,null,substr(c.cydjrq,1,4)||'年'||substr(c.cydjrq,5,2)||'月'||substr(c.cydjrq,7,2)||'日') cyrq00
  FROM zs_jbzms0 a,zy_brxxb0 c,bm_brxxb0 d
 WHERE bh0000 = '2026-住院-00002' AND mzzybz = '1'
 and a.zyghid=c.zyid00 and c.brid00=d.brid00