RT
解决方案 »
- sqlserver存储过程转oracle问题?
- 急!请教这个sql语句怎么写:两个条件查询,其中一个满足,另一个条件就不要加了
- 怎样获取触发器脚本?
- 哪位大哥能帮帮忙:PLSQL Developer连不上另一个数据库!!!!!
- oracle调用函数问题??急!!!
- 这样的SQL语句该怎么写呢,分组好象不行呢?
- 存储过程的问题!请大家指教!
- sql语言中有没有类似C语言中的switch case的语句??
- 初级问题!!如何在8i里创建自己的数据库????
- 谁知道.dat文件用什么编译请尽快在线等!!!!!!!
- oracle 的oms 在联上网的时候无法登陆,不上网可以是怎么回事呀
- 存储过程执行时快时慢
select * from ta a left join (select * from ta) b
on a.id=b.id不明白你的意思,可否贴出sql语句,再帮你分析下
a.well_common_name,
to_char(b.prod_date,'yyyy-mm-dd') prod_date,
b.prod_time,
c.PUMP_DEPTH,
e.STROKE_LENGTH,
f.STROKE_FREQUENCY,
g.PUMP_DIAMETER,
b.LIQ_PROD_DAILY,
b.OIL_PROD_DAILY,
b.WATER_CUT,
b.SALT_CUT,
c.STATIC_PRESSURE,
b.WATER_PROD_DAILY,
b.GAS_PROD_DAILY,
b.GAS_OIL_RATIO,
d.OIL_PROD_METHOD
from PC_PRO_WELL_VOL_DAILY b,PC_PRO_WELL_STATUS_DAILY d,CD_WELL_SOURCE a
left join TEMP_WELL_MECH_ALL c on c.well_id=a.well_id and c.test_date=(select max(test_date) from TEMP_WELL_MECH_ALL ff where ff.well_id=a.well_id and ff.test_date<=TO_DATE('2009-11-12', 'YYYY-MM-DD') and ff.pump_depth is not null )left join TEMP_WELL_MECH_ALL e on e.well_id=a.well_id and e.test_date=(select max(test_date) from TEMP_WELL_MECH_ALL ff where ff.well_id=a.well_id and ff.test_date<=TO_DATE('2009-11-12', 'YYYY-MM-DD') and ff.stroke_length is not null)left join TEMP_WELL_MECH_ALL f on f.well_id=a.well_id and h.STROKE_FREQUENCY is not null and f.test_date=(select max(test_date) from TEMP_WELL_MECH_ALL ff where ff.well_id=a.well_id and ff.test_date<=TO_DATE('2009-11-12', 'YYYY-MM-DD') and ff.STROKE_FREQUENCY is not null)left join TEMP_WELL_MECH_ALL g on g.well_id=a.well_id and g.test_date=(select max(test_date) from TEMP_WELL_MECH_ALL ff where ff.well_id=a.well_id and ff.test_date<=TO_DATE('2009-11-12', 'YYYY-MM-DD') and (ff.pump_diameter is not null or ff.pump_diameter is null))
where a.well_id=b.well_id and a.well_id=d.well_id
and b.prod_date=d.prod_date and c.well_id=e.well_id and h.well_id=g.well_id and e.well_id=h.well_id
and b.prod_date= TO_DATE('2009-11-12', 'YYYY-MM-DD')
and a.org_id IN (SELECT ORG_ID
FROM PC_ORGANIZATION_T
START WITH ORG_ID = 'O0HI4Ip6R6'
CONNECT BY PRIOR ORG_ID = PARENT_ID) order by well_common_name
Cause: <expression>(+) <relop> (<subquery>) is not allowed.
Action: Either remove the (+) or make a view out of the subquery. In V6 and before, the (+) was just ignored in this case.
ff.pump_diameter is not null or ff.pump_diameter is null
永远都是真,哈哈。