title: Cross-table UPDATE in SQLITE3
body: <p>In <code>SQL Server</code>, I can do something like this:</p>
  <pre><code>UPDATE tbl1 
     SET col2 = tbl2.col2 
    FROM table1 tbl1 
   INNER JOIN table2 tbl2 
      ON tbl1.col1 = tbl2.col1
  </code></pre>
  <p>I haven't bothered to look whether this is part of any SQL standard or not, and I'm sure there are other ways to do it, but it is <em>astoundingly</em> useful.</p>
  <p>Here's my problem. I need to do something similar <em>in SQL</em> (i.e, not a host language) with SQLITE3. Can it be done?</p>