CREATE OR REPLACE VIEW SD_HOSPITAL.VW_BM_SSBM00_DZBL
 (
 BMBH00, BMMC00, PXXH00

 )
 AS 
select  
BMBH00,
BMMC00,
PXXH00--排序序号
from BM_BMBM00
where  FLAG00='1' and czbz00='1'
and (BMXZ00='1' and BMMC00 like '%门诊%') or (BMXZ00='5' and BMMC00 like '%手术%')
--and BMXZ00 in ('0','1','5') and BMMC00 like '%手术%'
/