CREATE OR REPLACE VIEW vw_zy_mzzrgh (
   ghid00,
   brblh0,
   ghh000,
   brid00,
   xm0000,
   xb0000,
   csrq00,
   ghrq00,
   ghsj00,
   ghy000,
   ghyxm0,
   ghks00,
   ghksmc,
   sfzrzy,
   zrzyls )
AS
select a.GHID00,a.BRBLH0,a.GHH000,a.BRID00,a.XM0000,a.XB0000,a.CSRQ00,
a.GHRQ00,a.GHSJ00,a.GHY000,a.GHYXM0,a.GHKS00,b.bmmc00 as ghksmc,a.SFZRZY,a.ZRZYLS
  from sf_brxxb0 a,bm_bmbm00 b  where  a.ghks00=b.bmbh00 and   SFZRZY <>'N'
/