mysql join uodate

UPDATE adqm_data_source t1
JOIN source_info t2 ON t1.`source_name` = t2.`name` 
SET t1.`password` = t2.`password`;