Update with join in mysql

// Some code
UPDATE tableA ta 
JOIN tableB tb on ta.column = tb.column
SET ta.column = "random"
WHERE ta.column = "where1" AND tb.column = "where2";