1 2 3 4 5 6 7 8 9 10 11 12 | UPDATE t1SET Column1 = ( SELECT Columnx FROM t2 WHERE t2. KEY = t1. KEY ), Column2 = ( SELECT Columny FROM t2 WHERE t2. KEY = t1. KEY ),WHERE t1. KEY = ( SELECT KEY FROM t2 WHERE t2. KEY = t1. KEY ); |
原文：http://www.cnblogs.com/yzpopulation/p/4916896.html