title: SQL DELETE with 2 Joins?
body: <p>I have to delete a table, which has disabled users in it. The problem is, that I have to use the where clause in the end. This is the most important point, cause otherwise i can't test my query.</p>
  
  <p>The where clause is important, cause without it I would delete the whole database, not only the disabled users.</p>
  
  <pre><code>DELETE a
     FROM CONTENT_PERM a
     JOIN user_mapping b
       ON a.USERNAME = b.USER_KEY
          (JOIN CWD_USER c
             ON b.USERNAME = c.USER_NAME)
    WHERE c.ACTIVE = 'F';
  </code></pre>