转载链接地址: https://blog.csdn.net/u011974797/article/details/49618075

CREARE VIEW viewname AS 
select a from tableA
union all
select a from tableB

AS 后面不要用括号 '(';