How to delete a record using inner join on Oracle SQL?
<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>