在Oracle sql查询中使用“ zhoin”删除

在Oracle sql查询中使用“ zhoin”删除

根据我在上面的评论中链接的答案，此方法应该有效：

delete from(select pf.* From PRODUCTFILTERS pf where pf.id>=200 And pf.rowid in   (     Select rowid from PRODUCTFILTERS      inner join PRODUCTS on PRODUCTFILTERS.PRODUCTID = PRODUCTS.ID      And PRODUCTS.NAME= 'Mark'  ));

或者

delete from PRODUCTFILTERS where rowid in(select pf.rowid From PRODUCTFILTERS pf where pf.id>=200 And pf.rowid in   (     Select PRODUCTFILTERS.rowid from PRODUCTFILTERS      inner join PRODUCTS on PRODUCTFILTERS.PRODUCTID = PRODUCTS.ID      And PRODUCTS.NAME= 'Mark'  ));