SQL 两个无关的查询结果如何合并成多列

Question

表1字段A、B、C；表2字段D、E、F；
如何根据表1和表2信息，生成表3信息。

Answer 1

 select a.*, b.* from (select ROW_NUMBER() over(order by A) as id, * from table1) a
left join (select ROW_NUMBER() over(order by D) as id, * from table2) b on a.id = b.id