create or replace view sd_hospital.vw_ys_cyjbzd
(
JBMC00,ICD900,PYSM00,WBSM00
)
AS
select jbmc00,icd900,pysm00,wbsm00 from xt_icd900 where sybz00=1 and sfyx00=1
union all
select jbmc00,jbbh00 icd900,pysm00,wbsm00 from bm_zyjb00
/