select
sce.id as Id
sce.dirto as dirto
law.caseType as caseType,
law.caseNo as caseNo
vim.name as name,
los.place as place
from sce A
joins law B on A.caseId=B.Id
rigth outer joins vim C on B.Id= C.caseId
rigth outer joins los D on A.caseId = D.sceId;
------------------------ok
sce.id as Id
sce.dirto as dirto
law.caseType as caseType,
law.caseNo as caseNo
vim.name as name,
los.place as place
from sce A
joins law B on A.caseId=B.Id
rigth outer joins vim C on B.Id= C.caseId
rigth outer joins los D on A.caseId = D.sceId;
------------------------ok
解决方案 »
- 救命!!!IMP命令发生ORA-12154: TNS: 无法处理服务名的错误
- 各位高手,怎么在sqlplus下执行写好的函数或者是怎样运行存槠过程?
- 在linux下用proc/c++往oracle里写汉字的问题(汉字给拆了,不知如何解决)
- delphi+oracle 保存数据时报错: 没有连接事务管理器或没有管理器
- 介绍一些oracle的pl/sql的经典书籍
- 游标中传递参数错误原因???
- 如何配置名称服务器?
- 数据库初始化参数Init文件的配置是指哪个文件:init.ora 或 init(加上数据库名).ora
- 在win2000server上安装oracle8.1.7,按步骤卸载后,却无法安装,求解
- oracle的case语句转换成函数
- 在学习ORACLE中遇到的问题,期待解决。。。
- 如何缩短Oracle用户登录时间延迟?
from sce s, law lw, vim v, los ls
where s.caseId =law.Id(+) and lw.Id(+) = v.caseId and s.id(+) = ls.sceId