select *
from (select a, b, c, d
from t1
where c like 'C%'
and d like 'D'
UNION
select a, b, c, d
from t1
where c like 'C%'
and d like 'D') a1,
t2
where a1.a = t2.a(+)
and a1.b = t2.b(+)
from (select a, b, c, d
from t1
where c like 'C%'
and d like 'D'
UNION
select a, b, c, d
from t1
where c like 'C%'
and d like 'D') a1,
t2
where a1.a = t2.a(+)
and a1.b = t2.b(+)
解决方案 »
- occi 连接池中连接失效
- alter database clear logfile group 会否导致数据库恢复时数据丢失
- 关于oralce创建触发器的问题。
- sql server 2005导出到oracle 10g中报错
- 各位大虾,请问怎么给ORACLE传递数组呢???
- 多个IF条件怎么写呀
- 在客户端登陆远程服务器(通过代理中转),如何配置
- 请问insert into 可不可以插入多行呀
- tnsnames.ora,sqlnet.ora,init.ora ,listener.ora分别是用来做什么的,如何配置?
- oracle7.3.4安装后怎么建立实例? 在线等待
- 使用子查询的问题
- oracle10g迁移报错
from (select a, b, c, d
from t1
where c like 'C%'
and d like 'D'
UNION
select a, b, c, d
from t1
where c like 'C%'
and d like 'D') a1 left join
t2
on a1.a = t2.a
and a1.b = t2.b