Re: [sqlite] Update A table

[Dennis Cote]

Francisco,

You might want to add a coalesce() call so the f1 value is only changed 
if there is a corresponding value in table2.

update table1
set f1 = coalesce((select f1 from table2 where table2.f0 = table1.f0),  f1)

Dennis Cote