title: Delete with "Join" in Oracle sql Query
body: <p>I am not deeply acquainted with Oracle Sql Queries, therefore I face a problem on deleting some rows from a table which must fulfill a constraint which includes fields of another (joining) table. In other words I want to write a query to delete rows including JOIN. </p>
  
  <p>In my case I have a table <code>ProductFilters</code> and another table <code>Products</code> joined on fields <code>ProductFilters.productID = Products.ID</code>. I want to delete the rows from <code>ProductFilters</code> having an <code>ID</code> higher or equal to 200 and the product they refer has the name 'Mark' (name is a field in Product).</p>
  
  <p>I would like to be informed initially if JOIN is acceptable in a Delete Query in Oracle. If not how should I modify this Query in order to make it work, since on that form I receive an error:</p>
  
  <pre><code>DELETE From PRODUCTFILTERS pf 
  where pf.id&gt;=200 
  And pf.rowid in 
  (
       Select rowid from PRODUCTFILTERS 
       inner join PRODUCTS on PRODUCTFILTERS.PRODUCTID = PRODUCTS.ID 
       And PRODUCTS.NAME= 'Mark'
  );       
  </code></pre>