sql,把两个表中的两列数据合到一个表中
1个回答
展开全部
两个表的数据量一样的吗？
合并后创建新表吗？
需要借助辅助列
select
identity(int,1,1)
as
guid
,val
into
#1
from
table1
select
identity(int,1,1)
as
guid
,val
into
#2
from
table2
select
a.val
as
val1,b.val
as
val2
into
table3
from
#1
a
inner
join
#2
b
on
a.guid
=
b.guid
合并后创建新表吗？
需要借助辅助列
select
identity(int,1,1)
as
guid
,val
into
#1
from
table1
select
identity(int,1,1)
as
guid
,val
into
#2
from
table2
select
a.val
as
val1,b.val
as
val2
into
table3
from
#1
a
inner
join
#2
b
on
a.guid
=
b.guid
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
