示例12.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 11 行

CREATE VIEW student_people_view
AS
SELECT Name,City,Year
FROM student
UNION ALL
SELECT Name,City,Year FROM peopleCREATE VIEW student_people_view
AS
SELECT Name,City,Year
FROM student
UNION ALL
SELECT Name,City,Year FROM people