CREATE or REPLACE view V_XZQDMMC as
SELECT XZQDM, XZQMC
FROM Index_QXXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_DSXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_XZXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_CJXZQ
SELECT XZQDM, XZQMC
FROM Index_QXXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_DSXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_XZXZQ
UNION
SELECT XZQDM, XZQMC
FROM Index_CJXZQ