sqlserver数据将多个表或视图的数据合并到一个表或视图里的sql语句时间:2023-03-10 03:07:50 create view dbo.V_ZDUser_DDasselect * 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;