create or replace view vw_yj_yjywks as
select "BMBH00","BH0000","FLAG00","BMMC00","PYSM00","WBSM00",
"BMXZ00","FYBZ00","SYCW00","YJXX00","CKXX00","JZXX00","CZBZ00"
from BM_BMBM00 where BMXZ00 in ('0','1','5','J','9') and czbz00 in ('0','1') and flag00='1';