UPDATE `transformation bi`.`Table A` t1
     JOIN `transformation bi`.`Table B` t2
ON t1.name = t2.name
SET t1.value = t2.value`
 WHERE t1.Name = t2.Name;

UPDATE Table A, Table B
    SET Table A.yourFColm=yourVal,
    Table B.yourFColm=yourVal,
    Table A.yourFColm=yourVal,
    WHERE t1.Name = t2.Name;