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:
[crayon-5bedf9ccea122011254156/]

Example :
[crayon-5bedf9ccea127271194502/]

ENJOY!!

–Update one table from another table in MySql–