CREATE OR REPLACE VIEW SD_HOSPITAL.VW_BM_YYFPXM_MZDZBL
 (
 SFXMID, FPXMID, FPXMBH, FPXMMC

 )
 AS 
select c.sfxmid,d.fpxmid,d.bh0000 fpxmbh,d.xmmc00 fpxmmc from
bm_yysfxm c, bm_fpxm00 d
where c.mzfpid=d.fpxmid