There are many situations where we have to update one table’s field from another table based upon some common field in both table. Basically a inner join with update query:

Syntax is as follows:

Example :

ENJOY!!

–Update one table from another table in MySql–