select c1,c2 from (select c1,rownum r1 from tb1) t1 right join on (select c2,rownum r2 form tb2) t2 on t1.r1=t2.r2
select t1.c1,t2.c2 from (select C2,rownum as C22) t2 left join (select C1,rownum as c11) t1 on t2.c22 = t1.c11
(select C2,rownum as C22) (select C1,rownum as c11) 缺少from子句
select c1,c2 from (select c1,rownum r1 from tb1) t1 right join (select c2,rownum r2 form tb2) t2 on t1.r1=t2.r2一楼正解
select t1.c1,t2.c2 from from (select c1,rownum r1 from tb1) t1, (select c2,rownum r2 from tb2) t2 where t1.r1 = t2.r2 (+)条件后面的(+)是oracle数据库的外连接符号 在右边表示查询为左连接 在左边表示查询为右连接
select c1,c2 from
(select c1,rownum r1 from tb1) t1
right join on
(select c2,rownum r2 form tb2) t2
on t1.r1=t2.r2
left join (select C1,rownum as c11) t1 on t2.c22 = t1.c11
(select C2,rownum as C22)
(select C1,rownum as c11)
缺少from子句
(select c1,rownum r1 from tb1) t1
right join
(select c2,rownum r2 form tb2) t2
on t1.r1=t2.r2一楼正解
from (select c1,rownum r1 from tb1) t1,
(select c2,rownum r2 from tb2) t2
where t1.r1 = t2.r2 (+)条件后面的(+)是oracle数据库的外连接符号
在右边表示查询为左连接
在左边表示查询为右连接