sqlserver数据将多个表或视图的数据合并到一个表或视图里的sql语句

create view dbo.V_ZDUser_DD
as
select * from dbo.V_ZDUser_DD1 union all select * from dbo.V_ZDUser_DD2 union all select * from dbo.V_ZDUser_DD3
union all select * from dbo.V_ZDUser_DD4 union all select * from dbo.V_ZDUser_DD5;

原文：http://www.cnblogs.com/zhncnblogs/p/6610587.html