Hi guillaume,

i think an sql update instruction is just doing one record. so you have to put the update also in a scan.

select 2
scan
UPDATE 1 set 1.c = 2.c WHERE 1.a =2.a
endscan


I think the best way is to set a relation between 1 and 2 and then do a replace 1.c with 2.c where 1.a = 2.a