Update one table from another, uses an implicit join
UPDATE table1 AS A, table2 AS B SET A.fieldx = B.fieldz WHERE A.field7 = B.field3 and A.field2 = 'not me' -- etc...
desc