title: How to turn this MySQL SELECT query into a DELETE query?
body: <p>I want to delete certain items from the database. I have the following query:</p>
  
  <pre><code>SELECT * 
  FROM sheets, entries 
  WHERE entries.sheetID = sheets.id AND sheets.clientID = 13
  </code></pre>
  
  <p>This works, and returns 2 results.</p>
  
  <p>Now I want to turn this <code>SELECT</code> query into a <code>DELETE</code> query. However, the following doesn't work:</p>
  
  <pre><code>DELETE FROM sheets, entries 
  WHERE entries.sheetID = sheets.id AND sheets.clientID = 13
  </code></pre>
  
  <p>MySQL throws the following error:</p>
  
  <blockquote>
    <p>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 'WHERE entries.sheetID =
    sheets.id AND sheets.clientID = 13' at
    line 1</p>
  </blockquote>
  
  <p>What am I doing wrong here?</p>