CREATE VIEW VIEW_NAME
AS
SELECT * FROM
table1
UNION ALL
SELECT * FROM
table2
UNION ALL
SELECT * FROM
table3
UNION ALL
SELECT * FROM
table4
UNION ALL : 将多个视图合并
CREATE VIEW VIEW_NAME
AS
SELECT * FROM
table1
UNION ALL
SELECT * FROM
table2
UNION ALL
SELECT * FROM
table3
UNION ALL
SELECT * FROM
table4
UNION ALL : 将多个视图合并