 <p>I don't have access to an Oracle environment at the moment so I can't verify, but the following does work in SQL Server and will delete from the Orders table. If you want to delete from Order_Item, reverse the tables.</p> <pre><code>DELETE o FROM Orders o JOIN Order_Item oi ON o.order_id = oi.order_id WHERE [filter condition] </code></pre>