On Thu, Mar 8, 2012 at 9:53 AM, Marc L. Allen <mlal...@outsitenetworks.com> wrote: > I'm trying to do a multi-column update, adding values from another table. > Something like: > > UPDATE t1 SET a += (SELECT a FROM t2 WHERE t1.id = t2.id), > b += (SELECT b FROM t2 WHERE t1.id = t2.id);
This particular query need not be very inefficient if the pages needed to do the second sub-query are left in the cache from the first sub-query... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users