select
a.*,
b.*,
c.*,
d.*
from
a left join b on a.id = b.id
left join c on a.id = c.id
and d.other = a.other
这样写对不!
a.*,
b.*,
c.*,
d.*
from
a left join b on a.id = b.id
left join c on a.id = c.id
and d.other = a.other
这样写对不!
解决方案 »
- win7家庭普通版64位安装oracle10g问题!求解
- 谁有oracle9i unix管理手册 (急)
- 谁能评论一下这三个SQL的执行计划
- SID名,数据库名,网络服务名,这三者到底啥关系?
- 这个语句怎么写
- tns未建立监听的问题。
- 请问oracle9i中service名和SID的区别
- 郁闷:一个sql语句,因为update的值可能为空(就置零),所以要判断一下,但是怎么写都不对??
- ~~~~~~问题紧急,请大家务必帮小弟一把!~~~~~~~~~~~在线等!
- 经过大家指教,但是我的Oracle 9i还是有问题???!!!
- 请教一个Oracle9i操作问题
- 难得一见的怪问题,请各位高手进来切磋下....
a.*,
b.*,
c.*,
d.*
from
table1 a,
table2 b,
table3 c,
table4 d,
tabled e
where
b.id (+)= a.id
and c.id (+)= a.id
and d.oher = a.other
and e.other1 = d.other1
请问这个该怎么改啊,是不是改成这样
select
a.*,
b.*,
c.*,
d.*
from
table1 a left join table2 b on a.id = b.id
left join table3 c on a.id = c.id
and table4 d inner join table5 e on d.other1 = e.other1
and d.other = a.other