Igor Tandetnik-2 wrote > Or alternatively, without a WHERE clause: > > update a set i = coalesce((select i from b where b.a = a.a), i);
What I have used similar to this is: UPDATE a SET i = ifnull((select i from b where b.a = a.a), i); Tom -- View this message in context: http://sqlite.1065341.n5.nabble.com/updating-using-a-value-from-another-table-tp71588p71607.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users