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

2012-03-29

myslq视图里支不支持union语句为：CREATE VIEW mainview(ID)AS((SELECT ID FROM student)UNION (SELECT ID

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

探讨

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));
这样写报错！请大侠指点！