title: SQLite update field with count from another table
body: <p>I am trying prepare a table before exporting to CSV however the Sqlite administrator software I am using is reporting invalid syntax.  Anybody see whats gone wrong?</p>
  
  <pre><code>UPDATE 'tblTags'
  SET 'tagUsageCount' =
  (SELECT COUNT(*) FROM 'tblTagLinks'
  WHERE 'tblTagLinks'.'TLTagId' = 'tblTags'.'tagId')
  </code></pre>