Cross-table UPDATE in SQLITE3

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?

Answers


This works for sqlite:

UPDATE tbl1 SET col2 = (SELECT col2 FROM tbl2 WHERE tbl2.col1 = tbl1.col1)

Need Your Help

URL unknown chars are added to request data

jquery http

I want to send an URL to a server. The URL is encrypted and the server will recognize it. Unfortunately some chars are added to the URL, here: /event/seq/1/onclick. How did this happen? I am using

GET Consistency (and Quorum) in ElasticSearch

nosql elasticsearch

I am new to ElasticSearch and I am evaluating it for a project.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.