select d1.desc C, d2.desc Loc, d3.desc Item, c.sal
from c,
(select unit, desc from d where type = 'C') d1,
(select unit, desc from d where type = 'L') d2,
(select unit, desc from d where type = 'I') d3
where c.unit = d1.unit (+)
and c.unit = d2.unit (+)
and c.unit = d3.unit (+);问题不难,但是表结构很怪
from c,
(select unit, desc from d where type = 'C') d1,
(select unit, desc from d where type = 'L') d2,
(select unit, desc from d where type = 'I') d3
where c.unit = d1.unit (+)
and c.unit = d2.unit (+)
and c.unit = d3.unit (+);问题不难,但是表结构很怪
解决方案 »
- 请教一个存储过程,查询判断的,求高手赐教啊
- 求解分页存储过程调用问题
- 一年有365天 每天都有数据 我只想显示 每隔十天的数据
- oracle数据同步?
- 求助:一个棘手的循环更新问题100分(在线等)
- 为什么自己创建的数据库在ome中登录的时候只能以normal权限登录,不能以sysdba登录呢?
- 高手们,请教一个算法
- 急急急,求救! Oracle10g 导出失败
- 关于RBS
- 急求两表关联问题~~~~~~!!
- ORA-00604: error occurred at recursive SQL level 1和ORA-00018: maximum number of sessions exceeded 是什么错误怎么解决 谢谢
- 不通过Oracle Client安装程序如何实现ODBC驱动/SqlNet的安装和配置?急...分可加...来者有分
(select max(a.desc) from c b where c.unit = b.unit and b.tpye = 'L'),
(select max(a.desc) from c d where c.unit = d.unit and d.tpye = 'I'),c.sal
from c
(select max(b.desc) from c b where c.unit = b.unit and b.tpye = 'L') as Loc,
(select max(d.desc) from c d where c.unit = d.unit and d.tpye = 'I') as Item
,c.sal
from c
and c.unit = d2.unit (+)
and c.unit = d3.unit (+);
请问:这里的加号作什么用?