How do I merge two sqlite tables using a "where" condition?

See more:

VB

WPF

SQLite

Hello,

I have two tables. One of them has three columns "word", "count", and "value". The second one has two columns "word" and "value". In the second table, every field of the value column has an attached integer value. In the first table, the "value" column is empty or with placeholder values.

I want to import the values of the second table column "value" into the first table column "value" by matching the "word" column.

For a single row, the command would be something like

update table1 set 'value' = "valuefromTable2" where 'word' = "matchingWordFromTable2";

Since I have around 200k rows to update, I would rather use a potential SQLite feature (merge?)than a piece of code doing the work row by row. Do you know how to achieve that?

Thanks!