CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YK_YFYPSYL
 (
 YFBMBH, YPNM00, JZRQ00, FCSL00, ZHL000, K2J000

 )
 AS 
SELECT YFBMBH,YPNM00,JZRQ00,FCSL00,ZHL000,
(SELECT K2J000 FROM BM_YD0000 WHERE YPNM00=A.YPNM00)
FROM YF_YPMXZ0 A 
WHERE A.JZXZ00='C' AND A.RCLXBH IN ('03','09','10','14')   --增加14 外事用药
/