SQL UPDATE SET one column to be equal to a value in a related table referenced by a different column?

UPDATE table as table1 INNER JOIN table as table2 on table1.column1 = table2.column1
SET table1.column2 = table2.column4
WHERE table1.column3 = ‚randomCondition’;