oracle delete inner join,在Oracle sql Query中使用“Join”进行删除

根据我在上述评论中所提到的答案，这应该是有效的：

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'

)

);