SQL Server 转换为 Oracle 数据库遇到的一个SQL特例

SQL Server 转换为 Oracle 数据库遇到的一个SQL特例
记录下来，共以后参考

相关表联合条件删除某一个表的数据时 ，一下的SQL语句 SQL server 可以执行Oracle不可以执行：

delete RF_SURVEY_RESULT_DETAIL  from RF_SURVEY_RESULT_DETAIL 
inner join RF_SURVEY_OBJECT_RELATE on RF_SURVEY_RESULT_DETAIL.IN_SURVEY_OBJECT_ID = RF_SURVEY_OBJECT_RELATE.IN_SURVEY_OBJECT_ID
where RF_SURVEY_RESULT_DETAIL.IN_SURVEY_ID=77
and RF_SURVEY_RESULT_DETAIL.IN_SURVEY_SUBJECT_ID=1
and  RF_SURVEY_OBJECT_RELATE.IN_SURVEY_OBJECT_GROUP_ID =29  


--以下Oracle可以执行
delete  from RF_SURVEY_RESULT_DETAIL 
where RF_SURVEY_RESULT_DETAIL.IN_SURVEY_ID=770
and RF_SURVEY_RESULT_DETAIL.IN_SURVEY_SUBJECT_ID=10
and  RF_SURVEY_RESULT_DETAIL.IN_SURVEY_OBJECT_ID in (select IN_SURVEY_OBJECT_ID from RF_SURVEY_OBJECT_RELATE where IN_SURVEY_OBJECT_GROUP_ID =29  )