UPDATE skema.t1 as t1 SET t1_name= t2.t2_name FROM skema.t2 as t2 WHERE t1.id= t2.id AND t2.t2_name= 'XXX'