title: SQL DELETE with INNER JOIN
body: <p>There are 2 tables, <code>spawnlist</code> and <code>npc</code>, and I need to delete data from <code>spawnlsit</code>.
  <code>npc_templateid = n.idTemplate</code> is the only thing that "connect" the tables.
  I have tried this script but it doesn't work.</p>
  
  <p>I have tried this:</p>
  
  <pre><code>DELETE s FROM spawnlist s
  INNER JOIN npc n ON s.npc_templateid = n.idTemplate
  WHERE (n.type = "monster");
  </code></pre>