how to make update in a table using data from an other left join table

[cot_al]

When I look at the databse forum, i found the syntax for update very confusing.
Could it be consistent with other sql syntax :

UPTADE table1 Left join table2 on di1=id2 Set table1.field1=table2.field2 ?
Thanks

[AlexKemp]

RFO