On Fri, Apr 1, 2011 at 20:13, Igor Tandetnik <itandet...@mvps.org> wrote: > Or > update table_a set avalue=coalesce( > (select bvalue from table_b where akey=bkey), avalue);
Nice. But if table_b.value is null, it won't get copied into table_a. That would be a unexpected. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users