CREATE OR REPLACE VIEW VW_YS_YWMXXM
(sjxmbh, sjxmid, sjxmjc, sjlbbz, zxmbh0, gdxmbz, zxmid0, lbbz00, zlxmjc, fbzxbz, jgdw00, ckz000, dw0000, lbbh00, zhxmbz, bz0000, zyzbid, bbid00)
AS
SELECT Z.ZLXMBH SJXMBH,Z.ZLXMID SJXMID,Z.ZLXMJC SJXMJC,Z.LBBZ00, 
       Z.ZLXMBH ZXMBH0,
       'Y' GDXMBZ,Z.ZLXMID ZXMID0,
       Z.LBBZ00 ,Z.ZLXMJC ,
       Z.FBZXBZ ,Z.JGDW00 ,
       Z.CKZ000 ,Z.DW0000 ,
       Z.LBBH00 ,Z.ZHXMBZ ,
       Z.BZ0000 ,Z.ZYZBID, 
       Z.BBID00 
FROM   BM_ZLZD00 Z
WHERE  Z.ZHXMBZ='0'
UNION ALL
SELECT Z.ZLXMBH, Z.ZLXMID, Z.ZLXMJC, '2',X.ZLXMBH, 'Y', X.ZLXMID,
       X.LBBZ00, X.ZLXMJC, X.FBZXBZ, X.JGDW00, X.CKZ000, X.DW0000,
       X.LBBH00, X.ZHXMBZ, X.BZ0000, X.ZYZBID, X.BBID00
FROM   BM_ZLZD00 Z, XT_ZHMX00 O ,BM_ZLZD00 X 
WHERE  Z.ZLXMID=O.ZHXMID AND O.ZLXMID=X.ZLXMID and Z.ZHXMBZ='1';