On 2016/09/22 9:04 PM, Richard Hipp wrote:
Our current schedule for the next SQLite release (3.15.0) is for 2016-10-14.
2.2. Row Values In UPDATE Statements
Row values can also be used in the SET clause of an UPDATE
<https://www.sqlite.org/draft/lang_update.html> statement. The RHS must
be a list of column names. The LHS can be any row value. For example:
UPDATE tab3
SET (a,b,c) = (SELECT x,y,z
FROM tab4
WHERE tab4.w=tab3.d);
WHERE tab3.e BETWEEN 55 AND 66;
---- That's an answered need if ever I saw one - Much appreciation!!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
