CREATE OR REPLACE VIEW SD_HOSPITAL.VW_WZ_CGJH00_DSQL
 (
 CGDJH0, CGJHDH, WZMC00, WZGG00, WZSXMC, WZXH00, WZDW00, JHSL00, CGDJ00, 
CGJE00, CGKSMC, GYSMC0, CGQRRQ, CGJHRQ, ZBXH00, BZ0000, SCCJZW, KCZSL0, 
GHDWID, GHDWMC, CGMXID

 )
 AS 
select
   R.CGDJH0,R.CGJHDH,a.WZMC00,a.WZGG00,a.WZSXMC,a.WZXH00,a.WZDW00,
   a.JHSL00,a.CGDJ00,round(a.CGDJ00*a.JHSL00,2) CGJE00,R.CGKSMC,a.GYSMC0,
     substr(R.CGQRRQ,1,4)||'年'||substr(substr(R.CGQRRQ,1,6),5,6)
     ||'月'||substr(R.CGQRRQ,7,8)||'日'  CGQRRQ,
          substr(R.CGJHRQ,1,4)||'年'||substr(substr(R.CGJHRQ,1,6),5,6)
     ||'月'||substr(R.CGJHRQ,7,8)||'日'  CGJHRQ,a.ZBXH00,a.BZ0000,a.SCCJZW,a.KCZSL0,
     a.GHDWID,a.GYSMC0,a.CGMXID
   from VW_WZ_CGJHMX a,VW_WZ_CGJH00 R,WZ_WZXX00 b --,BM_WZSCCJ d
   where  a.CGJHDH=R.CGJHDH
     and  a.WZID00=b.WZID00
     --and  b.CJID00=d.CJID00(+)
/