title: How to delete a record using inner join on Oracle SQL?
body: <p>I have 3 tables</p>
  
  <p>Table A :</p>
  
  <pre><code>| id_A | Data ... |
  </code></pre>
  
  <p>Table B :</p>
  
  <pre><code>| id_B | Data ... |
  </code></pre>
  
  <p>Join A_B</p>
  
  <pre><code>| id_A | id_B |
  </code></pre>
  
  <p>Those tables are an example of my situation. Well, I am trying to delete many records from Join A_B depending on many conditions like the name of A is X and name of B is Y.</p>
  
  <p>When I execute a SELECT it works, but with DELETE It doesn't.</p>
  
  <p>This is my resquest:</p>
  
  <pre><code>DELETE A_B FROM A 
  INNER JOIN A_B 
    ON (A.ID = A_B.A_ID) 
  INNER JOIN B 
    ON (B.ID = A_B.B_ID) 
  WHERE B.NAME IN ('X', 'Y') 
  AND A.NAME = 'Z';
  </code></pre>
  
  <p>It says :</p>
  
  <pre><code>Erreur SQL : ORA-00933: SQL command not properly ended
  00933. 00000 -  "SQL command not properly ended"
  </code></pre>