直接在查询分析器:create view xxx
as
select fileType, fileName, description from tabFile union select fileType, fileName, description from tablOtherFile
as
select fileType, fileName, description from tabFile union select fileType, fileName, description from tablOtherFile
As
select fileType, fileName, description from tabFile
union
select fileType, fileName, description from tablOtherFile
1:应该没问题啊
2:最好用union all(参考联机帮助)