SQL Statement to update one table field with another table field

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
Tagged: Tags:

Leave A Comment?