Update field from field in linked table

[Pierre Rossel]

Hello,

I would like to do something like that:

UPDATE t2 
SET t2.X = t1.X 
FROM table1 t1 inner join table2 t2 on t1.A = t2.A 

In English: 

Copy values from one table to another where field A matches.

Tried in Vstudio, but it doesn't seem that Valentina SQL support the FROM in
an UPDATE statement.

Any other idea to avoid copying values one at a time ?

Thank you.

Pierre Rossel