title: Multiple delete statements with single query
body: <p>Given two tables, <code>photos</code> and <code>keywords</code>, where <code>photos.ID = keywords.photos</code>, how can I delete the same rows from both tables in a single query?  The <code>photos</code> table has a single record, while <code>keywords</code> has 9 references to the <code>photos</code> record.</p>
  
  <p>I've tried </p>
  
  <pre><code>DELETE FROM photos 
  INNER JOIN keywords ON photos.ID = keywords.photo 
  WHERE photos.ID = 262;
  </code></pre>
  
  <p>I get a Error 1064 stating an error exists starting at <code>INNER JOIN keywords</code> and continuing for the rest of the statement.</p>
  
  <p>However, when I conovert the <code>DELETE</code> statement to a <code>SELECT *</code> via</p>
  
  <pre><code>SELECT * FROM photos
  INNER JOIN keywords ON photos.ID = keywords.photo
  WHERE photos.ID = 262;
  </code></pre>
  
  <p>, I get a set of 9 rows returned.</p>