CREATE OR REPLACE VIEW SD_HOSPITAL.VW_ZS_YPYF00
 (
 YFID00, YPYFMC, WBSM00, PYSM00, YPYFBZ, ORDER0, PLXH00, YXTZBZ, MRQSSJ, 
BZ0000, XEJSXM

 )
 AS 
select
         yfid00,     --药品用法ID
         ypyfmc,     --药品用法名称
         wbsm00,     --五笔码
         pysm00,     --拼音码
         ypyfbz,     --药品用法标志
         order0,		 --排序字段
         plxh00,     --字符型排列序号
         YXTZBZ,
         MRQSSJ,
         BZ0000,
         XEJSXM
from BM_YPYF00 where sybz00 in ('1','3') and tybz00='1'
/