As geervani indicated you can definitely use FROM clause in UPDATE but not in the example given.

I would do:

update a1

Set a1.column= a2.column

From table as a1 inner join table2 as a2

On a1.column1=a2.column2

I want my point back 😀

Victor