如果你就一样,那么就用个inner join 1 = 1 就可以了。如果2行以上那怎么搞呢?
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
22,209
社区成员
121,730
社区内容
加载中
试试用AI创作助手写篇文章吧