如何修复ORA-00933命令未正确结束的错误

Question

(select DETAIL_ID 
from OD_TO_SOURCE 
where OD_SOURCE_ID='S1Mh8trcQL6ggWbt001001') OD_TO_SRC 
inner join obligation_detail 
on OD_TO_SRC.OBLIGATION_DETAIL_ID=obligation_detail.detail_id 
where obligation_detail.record_status = '0' 
and obligation_detail.obligation_detail_status = '2' 
and obligation_detail.settlement_date = '20181217'

以上sql显示

ORA-00933命令未正确结束

错误。有人能告诉我问题出在哪里吗？谢谢

Answer 1

我怀疑这就是你想在这里做的：

select
ots.DETAIL_ID
from OD_TO_SOURCE ots
inner join obligation_detail od
on ots.OBLIGATION_DETAIL_ID = od.detail_id
where
ots.OD_SOURCE_ID = 'S1Mh8trcQL6ggWbt001001' and
od.record_status = '0' and
od.obligation_detail_status = '2' and 
od.settlement_date = '20181217'

看起来您正试图将OD_TO_SOURCE表上的子查询联接到查询的其余部分。但是，我认为没有必要使用子查询。

Answer 2

希望这能帮助你，这个查询不完整，select语句在哪里？

select OD_TO_SRC .* from 
(select DETAIL_ID 
from OD_TO_SOURCE 
where OD_SOURCE_ID='S1Mh8trcQL6ggWbt001001') OD_TO_SRC 
inner join obligation_detail 
on OD_TO_SRC.OBLIGATION_DETAIL_ID=obligation_detail.detail_id 
where obligation_detail.record_status = '0' 
and obligation_detail.obligation_detail_status = '2' 
and obligation_detail.settlement_date = '20181217