UPDATE t1 SET t1.c1 = new_value FROM t2 WHERE t1.c2 = t2.c2; Code language: SQL (Structured Query Language) (sql)