Update sql with join table

update TABLE_A
set TABLE_A.COLUMN_A = TABLE_B.COLUMN_A
from TABLE_A
join TABLE_B on TABLE_A.COLUMN_PK = TABLE_B.COLUMN_PK