UPDATE t1
SET t1.c1 = new_value
FROM t2
WHERE t1.c2 = t2.c2;

Code language: SQL (Structured Query Language) (sql)