update the_table
   set col1 = t2.col2
  from the_table t1
     , other_table t2
 where t2.id = t1.id
   and t1.somecol = "some value"
   and t2.anothercol = "some other value"