with
a1 as (select a.x,rownum rn from a),
b1 as (select a.y,rownum rn from b)
select a1.x,b1.y from a1,b1 where a1.rn=b1.rn;
你要确定2张表记录数相等,不然就改成左右连接全外连接吧
a1 as (select a.x,rownum rn from a),
b1 as (select a.y,rownum rn from b)
select a1.x,b1.y from a1,b1 where a1.rn=b1.rn;
你要确定2张表记录数相等,不然就改成左右连接全外连接吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货