Differences between SQL Server and MYSQL when using the update inner JOIN

SQL Server

Update Tb_user     Set           "don't add tb_user alias usr from Tb_user usr before pass here."   Innerjoinon=  addr.naddressid    where usr.id  =123  

Mysql

UPDATEMem_world asMw1INNER JOINMem_world asMW2 onMw1.parentid=Mw2.widSEToWS. Level =MW2. Level WHEREMw2.baseid= 107  andMw2.parentid= 0  andMw2.size> 1;

One is set and then associated, and the other is the first association and then set.

Differences between SQL Server and MYSQL when using the update inner JOIN