UPDATE table1
SET table1.c1 = new_value
FROM table2
WHERE table1.c2 = table2.c2;