ORA-OO933 SQL命令未正常结束

[f504501983]

delete from ep_alarm_detail_log t join ep_alarm_log aa on aa.alarm_log_id=t.alarm_log_id where 1=1;
就是这个句子，一执行就报错，然后在join的j下有个短红杠。我怀疑是join的问题。求解释。

[rfb0204421]

delete from ep_alarm_detail_log t
where exists
(select 1 from ep_alarm_log aa
where aa.alarm_log_id=t.alarm_log_id )

試試.

[rfb0204421]

delete from ep_alarm_detail_log t
where exists
(select 1 from ep_alarm_log aa
where aa.alarm_log_id=t.alarm_log_id )

試試.

[f504501983]

[Quote=引用 2 楼 rfb0204421 的回复:]

delete from ep_alarm_detail_log t
where exists
(select 1 from ep_alarm_log aa
where aa.alarm_log_id=t.alarm_log_id )

試試.
[/Quote]
看样子delete就不能和join连用啊

[天河书阁 VicRestart]

按着这个例子来改吧：
DELETE mwb FROM mem_world_building AS mwb INNER JOIN mem_world AS mw
ON mwb.wid = mw.wid
where mw.type between 11 and 15
and baseid = 107;