Copy data from one table to another in MySQL

UPDATE table_to_be_updated INNER JOIN source_table
ON (table_to_be_updated.field_to_match = source_table.field_to_match)
SET table_to_be_updated.field_to_be_updated = source_table.source_field