title: Delete all rows in a table based on another table
body: <p>I can't seem to ever remember this query!</p>
  
  <p>I want to delete all rows in table1 whose ID's are the same as in Table2.</p>
  
  <p>So:</p>
  
  <pre><code>DELETE table1 t1
   WHERE t1.ID = t2.ID
  </code></pre>
  
  <p>I know I can do a WHERE ID IN (SELECT ID FROM table2) but I want to do this query using a JOIN if possible.</p>