myslq视图里支不支持union
语句为：
CREATE VIEW mainview(ID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
这样写报错！请大侠指点！

[解决办法]
CREATE VIEW mainview(ID)
AS
SELECT ID FROM student
UNION
SELECT ID FROM teacher;
[解决办法]