CREATE VIEW SD_HOSPITAL.VW_ZY_BRFY00
 (
 ZYID00, KDBQ00, HJJE00, QDRQ00, YPBZ00

 )
 AS 
select b.ZYID00,
      KDBQ00,
      a.HJJE00,
      a.QDRQ00,
      case when xmbh00 in('9999999997','9999999998','9999999999') or sflb00=3 then 0 else 1 end YPBZ00   --0药品1治疗项目
from ZY_FYMX00 a,ZY_BRFY00 b where a.DJH000=b.DJH000
/