title: Delete using Inner Joins
body: <p>So I have this correlated subquery, and I was reading that this is not the most efficient way to go about this. Hence, I want to convert this query to an INNER JOIN query.</p>
  
  <pre><code>DELETE FROM tableA
  WHERE EXISTS (
             SELECT fieldA
             FROM tableB
             WHERE tableB.fieldA= tableA.fieldA)
  </code></pre>
  
  <p>I tried something like this:</p>
  
  <pre><code>DELETE a 
  FROM TableA a
  INNER JOIN TableB b
  ON a.fieldA = b.fieldA
  </code></pre>
  
  <p>Which resulted in an <code>Error while executing SQL query on database 'DB': near "a": syntax error</code></p>
  
  <p>All of my search results on here yielded approximately the same query (similar to what I have tried)</p>