MYSQL update cross table
--------------------------------

UPDATE T2,T1
SET T2.field1=T1.field2
WHERE T2.field3=T1.field4

==========
T2 : table that want update
T1 : table that want referrence
fieldx : field in that table