The Transact-SQL UNION set operator can be used within a view to combine the results of two or more queries from separate tables into a single result set.

• Transact-SQL UNION集合运算符可在视图内使用,将单独表的两个或多个查询的结果组合到单一的结果集中。