--我只做了两个表的例子三个表以此类推
create table a (DD int, we int , tr int, ty int)
insert into a select 34, 45, 67, 78
insert into a select 23, 56 ,78, 89create table b (TT int , rt int , ui int)
insert into b select 23 ,45, 67
insert into b select 78, 89, 45--编号放临时表
select IDENTITY ( int ) as id,* into #t from a
select IDENTITY ( int ) as id,* into #t1 from bselect DD,we,tr,ty,TT,rt,ui from #t inner join #t1 on #t.id=#t1.iddrop table #t
drop table #t1 drop table a
drop table b
create table a (DD int, we int , tr int, ty int)
insert into a select 34, 45, 67, 78
insert into a select 23, 56 ,78, 89create table b (TT int , rt int , ui int)
insert into b select 23 ,45, 67
insert into b select 78, 89, 45--编号放临时表
select IDENTITY ( int ) as id,* into #t from a
select IDENTITY ( int ) as id,* into #t1 from bselect DD,we,tr,ty,TT,rt,ui from #t inner join #t1 on #t.id=#t1.iddrop table #t
drop table #t1 drop table a
drop table b
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货