create or replace view vw_ba_sszltj as
select
ba.LSH000,
ba.CYRQ00,
ba.CYKBMC,
(case when QKYHDJ='Ⅰ/甲' then 1 else 0 end) YIJIA,
(case when QKYHDJ='Ⅰ/乙' then 1 else 0 end) YIYI,
(case when QKYHDJ='Ⅰ/丙' then 1 else 0 end) YIBING,
(case when QKYHDJ='Ⅰ/其他' then 1 else 0 end) YIQITA,
(case when QKYHDJ='Ⅱ/甲' then 1 else 0 end) ERJIA,
(case when QKYHDJ='Ⅱ/乙' then 1 else 0 end) ERYI,
(case when QKYHDJ='Ⅱ/丙' then 1 else 0 end) ERBING,
(case when QKYHDJ='Ⅱ/其他' then 1 else 0 end) ERQITA,
(case when QKYHDJ='Ⅲ/甲' then 1 else 0 end) SAJIA,
(case when QKYHDJ='Ⅲ/乙' then 1 else 0 end) SAYI,
(case when QKYHDJ='Ⅲ/丙' then 1 else 0 end) SABING,
(case when QKYHDJ='Ⅲ/其他' then 1 else 0 end) SAQITA
from BA_BRZYXX BA join  BA_BASSSB SS on BA.LSH000=SS.LSH000 join XT_CM3000 xt on XT.CM3000 =SS.SSM000  and (XT.LB0000='手术' or XT.LB0000='介入治疗');