myslq视图里支不支持union解决思路

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;
[解决办法]