title: Error Query: DELETE and LEFT JOIN
body: <pre><code>DELETE FROM programSchedule 
  LEFT JOIN program ON programSchedule.pid = program.id 
  WHERE program.channel_id = 10
  </code></pre>
  
  <p>I get this 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 'LEFT JOIN program ON
    programSchedule.pid = program.id' at
    line 1</p>
  </blockquote>
  
  <p>Why?</p>