sql 语句将两张表合并成一张表

比如
表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