A simple statement to update one table field with another table field value.
UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate =theValueTable.valueToUpdate