Mysql update field using another table

A simple usage of updating a field using another tables field

MySQL syntax: