UPDATE & JOIN 的妙用 2009/02/102009/02/10oneLeave a comment UPDATE table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.id SET t1.val = t2.val sigh, 手册还是要多看亚。