Check out example codes for "mysql update table from select on another table". It will help you in understanding the concepts better.

Code Example 1

UPDATE TableB 
SET TableB.value = (
    SELECT TableA.value 
    FROM TableA
    WHERE TableA.name = TableB.name
);

Learn ReactJs, React Native from akashmittal.com