title: MYSQL - Delete Query with Join
body: <p>I have checked the answered questions. But, solutions are not working for me.</p>
  
  <pre><code>DELETE FROM TEST2
  INNER JOIN TEST1 on TEST1.FIELD2 = TEST2.FIELD2
  WHERE TEST1.FIELD1 = 22;
  </code></pre>
  
  <p>When i execute this query, i am getting the following error in phpmyadmin.</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 
  for the right syntax to use near 'INNER JOIN TEST1 on TEST1.FIELD2 = TEST2.FIELD2' at line 2
  </code></pre>
  
  <p>I am getting tired. I need help. Thanks in advance.</p>