title: Oracle Delete "Many-to-Many" relationship table data
body: <p>I have 3 tables, which are in a many-to-many relationship. I.e:</p>
  
  <pre><code> Create Table Product(ProductId number(18,0) NOT NULL);
  
   Create Table Customer(CustomerId number(18,0) NOT NULL);
  
   Create Table CustomerProduct(CustomerId number(18,0) NOT NULL,ProductId number(18,0) NOT NULL);
  </code></pre>
  
  <p>Since CustomerProduct table is referencing both Product and Customer table. I am trying to delete the data from CustomerProduct table. </p>
  
  <p>I only can find something like:</p>
  
  <pre><code>DELETE FROM
  (
     SElECT CustomerProduct.* FROM CustomerProduct
     INNER JOIN Product ON Product.ProductId = CustomerProduct.ProductId
     INNER JOIN Customer ON Customer.CustomerId = CustomerProduct.CustomerId
     WHERE Product.ProductId = 1 AND Customer.CustomerId = 7
  
  );
  </code></pre>
  
  <p>NOTE: there is no CASCADE delete defined on foreign keys... Oracle doesn't allow me to do something I can do in SQL SERVER</p>
  
  <pre><code>DELETE A
  FROM A
  INNER JOIN B on a.Id = b.id
  WHERE b.Id = 2.....
  </code></pre>