Re: [sqlite] updating records in table A from joined records intable B

[Igor Tandetnik]

David Garfield <garfi...@irving.iisd.sra.com> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users