System.Data.SQLite

Is there a way to do an update of one table another?  For example

UPDATE TABLE_A
SET name = TABLE_B.name
INNER JOIN TABLE_B
ON TABLE_A.id = TABLE_B.id

Thanks in advance

I went through this recently in my SQLite app, and came to the conclusion that you have to do it as a sub-select, e.g.:

update table_a set name = (select table_b.name from table_b where table_b.id = table_a.id)

SQLite seems to process this fairly efficiently as far as I can tell.

Thank you.  I tried this but that table is really big and it was not performing well even if it does work.  I had indexes in place as well.

Is the update / subselect query as simple as you show in the example, or is it more complex?  If it's complex, it might improve things at least to the point of usability to create a temporary table, e.g.:

Alternately, it looks like with some proper trickery, insert or replace may be able to do what you want: http://www.mail-archive.com/sqlite-users@sqlite.org/msg27207.html.  Consider this example:

create table foo (id integer primary key, name text not null, extra text not null);
create table bar (id integer primary key, name text not null);
insert into foo values (1, "one", "first");
insert into foo values (2, "twox", "second");
insert into bar values (2, "two");

insert or replace into foo (id, name, extra)
select bar.id, bar.name, foo.extra
from bar left join foo on bar.id = foo.id;

I saw a post by Richard Hipp about doing this (INSERT OR REPLACE) as well.  My experience with INSERT OR REPLACE is that the primary keys are not preserved.  I will have to try it out again.  Thanks