<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>

I've discovered this can be done with
```
INSERT OR REPLACE INTO
```
. A little more verbose than T-SQL's equivalent, but just as handy.