select identity(int,1,1) as id,* into #t1 from A表
select identity(int,1,1) as id,* into #t2 from B表
select identity(int,1,1) as id,* into #t3 from C表select
a.col1,
a.col2,
a.col3,
b.col1,
b.col2,
c.col1,
c.col2
from
(select id from #t1
union
select id from #t2
union
select id from #t3) v
left join
#t1 a
on
v.id = a.id
left join
#t2 b
on
v.id = b.id
left join
#t3
on
v.id = c.id
select identity(int,1,1) as id,* into #t2 from B表
select identity(int,1,1) as id,* into #t3 from C表select
a.col1,
a.col2,
a.col3,
b.col1,
b.col2,
c.col1,
c.col2
from
(select id from #t1
union
select id from #t2
union
select id from #t3) v
left join
#t1 a
on
v.id = a.id
left join
#t2 b
on
v.id = b.id
left join
#t3
on
v.id = c.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货