表A: 表B:
aid name1 bid name2
------------------------- --------------------------------------------
1 aa 4 dd
2 bb 5 ee
3 cc
要得到如下结果:
表C:
aid name1 bid name2
--------------------------------------------------------------------------
1 aa 4 dd
2 bb 5 ee
3 cc
注意:两表中没有可关联的相同的数据,只是简单的将表B中的列加入到表A的列后面
实现方法如下代码:
select a.aid,a.name1,b.bid,b.name2 from
(select ROW_NUMBER() OVER (order by aid)as RowNumber,aid,name1 from A) a
full join
(select ROW_NUMBER() OVER (order by bid)as RowNumber,bid,name2 from B) b
on a.rownumber = b.rownumber