17,377
社区成员
发帖
与我相关
我的任务
分享
--最好应该有一个排序字段,否则,如果从表中读出的数据无法保证顺序
SELECT A, B
FROM (SELECT rownum aid, A FROM (SELECT A FROM t1 ORDER BY a)),
(SELECT rownum bid, B FROM (SELECT B FROM t2 ORDER BY b))
WHERE aid = bid(+)
with tab1 as(
select 'X' A from dual
union all
select 'Y' A from dual
union all
select 'Z' A from dual
)
,tab2 as(
select 'A' B from dual
union all
select 'B' B from dual
)
select A,B from
(select rownum as id,A from tab1),
(select rownum as xid,B from tab2)
where id = xid(+)