比如
表1结构为:
A B C
1 2 3
表2结构为:
D E F
4 5 6
我要得到的结果为:
A B C D E F
1 2 3 4 5 6
select A,B,C,D,E,F from
(select row_num() over(order by A) as tabn1,* from 表1) as a
LEFT JOIN
(select row_num() over(order by D) as tabn2,* from 表2) as b
ON tabn1=tabn2