UPDATE TABLE t1 SET t1.code1=
(SELECT code1 FROM TABLE2 t2 WHERE t1.code2=t2.code2) -------条件,T1表的code1是T2表中的code1时
WHERE EXISTS
(SELECT code1 FROM TABLE2 t2 WHERE t1.code2=t2.code2) -------条件,T1表的code1是T2表中的code1时
WHERE EXISTS
( SELECT T1中需要插入的存在于T2的字段 FROM TABLE2 t2 WHERE t1.code2=t2.code2)