--PROMPT  不包含管理员的医生组明细
CREATE OR REPLACE VIEW VW_ZS_YSZMX0_NOGL  
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- YANGY       2012.06.29  CREATE
-- ----------  ----------  -------------------------------------------------------------------
 AS 
select a.YSZID0,
       a.YSBH00,
       a.YSXM00,
       a.YSLB00,
       a.KSRQ00,
       a.KSSJ00,
       a.JSRQ00,
       a.JSSJ00,
       a.XSXH00,
       a.YSZT00,
       a.ZMXID0  from ZS_YSZMX0 a, BM_YGBM00 b where a.YSBH00=B.YGBH00 -- and b.YGXZ00 not like '%5%'
/