This is a handy little snippet if you need to update one field (source) in one table (table 1) from the results of a field in a related table (table 2)

UPDATE table1 JOIN table1 ON table1.id = table2.id SET table2.source = table1.source