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;

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

标签：creat   union   数据   rom   create   user   多个   use   union all