CREATE OR REPLACE VIEW vw_yk_kssjb0_mz (
   mzzybz,
   ghid00,
   ypnm00,
   ypmc00,
   ypgg00,
   ddd000,
   ypzsl0,
   lsdj00,
   fyrq00,
   zhl000,
   yyid00,
   ghks00,
   jzrq00,
   k2j000,
   ddd001,
   kssjb0)
AS
select '0'MZZYBZ,b.GHID00,d.YPNM00,d.YPMC00,d.YPGG00,c.DDD000,d.YPZSL0,d.LSDJ00,b.FYRQ00,d.zhl000,e.yyid00,b.GHKS00,
b.JZRQ00,c.K2J000,C.DDD001,C.kssjb0
  from YF_MZCF00 b,YF_MZCFMX d,BM_YD0000 c,bm_bmbm00 e   
  where b.CFLSH0=d.CFLSH0 and d.YPNM00=c.YPNM00 and b.yfbmbh=e.bmbh00 and c.KSSJB0>0