如果表1和表2沒关联字段,只是需要顺序的將表2的结果集添加到表1结果集显示出来可以这么做:
;with tb01 as
(
select
row_number() over(order by 列a) as id,
列a, 列b
from 表1
),
tb02 as
(
select
row_number() over(order by 列1) as id,
列1, 列2
from 表2
)
select t1.列a, t1.列b, t2.列1, t2.列2
from tb01 as t1
left join tb02 as t2
on t1.id = t2.id