Written by Mike Zriel
How to Update one table from an SQL statement from another table.
UPDATE `table1` a, `table2` b
Field2 is the field your matching table1 and table2
Field1 is the field you want to update, you can add more field, just make sure to separate them by a coma `,`.
This is only valid for MySQL.