title: Deleting rows from SQLite table when no match exists in another table
body: <p>I need to delete rows from an SQLite table where their row IDs do not exist in another table. The SELECT statement returns the correct rows:</p>
  
  <pre><code>SELECT * FROM cache LEFT JOIN main ON cache.id=main.id WHERE main.id IS NULL;
  </code></pre>
  
  <p>However, the delete statement generates an error from SQLIte:</p>
  
  <pre><code>DELETE FROM cache LEFT JOIN main ON cache.id=main.id WHERE main.id IS NULL;
  </code></pre>
  
  <p>The error is: <em>SQLite Error 1 - near "left": syntax error.</em> Is there another syntax I could use?</p>