In SQL Server
, I can do something like this:
UPDATE tbl1
SET col2 = tbl2.col2
FROM table1 tbl1
INNER JOIN table2 tbl2
ON tbl1.col1 = tbl2.col1
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 astoundingly useful.
Here's my problem. I need to do something similar in SQL (i.e, not a host language) with SQLITE3. Can it be done?
See Question&Answers more detail:os