CREATE TABLE a( NAME INT, age int ) CREATE TABLE b( height INT, weight int ) INSERT INTO a VALUES (1,2) INSERT INTO b VALUES (2,3) SELECT * FROM a; SELECT * FROM b SELECT * FROM a UPDATE ab SET ab.name=ac.height FROM a AS ab ,b AS ac WHERE ab.age=ac.height
根据多表条件更新表.............. 一条sql语句.............
原文：http://www.cnblogs.com/gaocong/p/4432849.html