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
解决方案 »
- Oracle 的 table space是干什么的?为什么要创建?
- sleect count(*) 慢!!!!!!!!!!!!
- 高分请教:linux下oracle的安装问题
- oracle中如何实现字符串的比较?
- 求写一个sql,根据条件不同进行不同的update操作,急等,谢谢!
- 求助一条简单的SQL语句
- 请问在AIX下执行sqlplus / as sysdba是什么意思?
- 怎么用sql plus insert 日期型数据
- 这样的需求, 如何来设计数据库的table schema ?
- 请教各位大虾:如何在VB中向ORA数据库写入日期型字段的值?
- 在学习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