David Garfield <[email protected]> wrote: > UPDATE table_a SET avalue=(SELECT bvalue FROM table_b WHERE akey=bkey) > WHERE EXISTS(SELECT 1 FROM table_b WHERE akey=bkey);
Or
update table_a set avalue=coalesce(
(select bvalue from table_b where akey=bkey), avalue);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
