title: How do I make an UPDATE while joining tables on SQLite?
body: <p>I tried :</p>
  
  <pre><code>UPDATE closure JOIN item ON ( item_id = id ) 
  SET checked = 0 
  WHERE ancestor_id = 1
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>UPDATE closure, item 
  SET checked = 0 
  WHERE ancestor_id = 1 AND item_id = id
  </code></pre>
  
  <p>Both works with MySQL, but those give me a syntax error in SQLite.</p>
  
  <p>How can I make this UPDATE / JOIN works with SQLite version 3.5.9 ?</p>