How do I do a JOIN in an UPDATE query with MySQL

As a follow up to my June 22nd post on doing a JOIN in an UPDATE with SQL Server, I just needed to do the same in MySQL. Here's the syntax I used:

As you can see, the order of things is a little different in MySQL vs SQL Server.