从另一列更新列距离两个表

我建议在更新语句中使用join。

UPDATE tblOne 
SET tblOne.Type = tblTemp1.Type
FROM tblTemp2
INNER JOIN tblTemp1 ON tblTemp1.Name = tblTemp2.Name
WHERE tblOne.Id = tblTemp2.Id

http://msdn.microsoft.com/en-us/library/aa260662%28SQL.80%29.aspx

UPDATE tblOne
SET
tblOne.Type = tblTemp1.Type
WHERE
tblOne.Id = tblTemp2.Id
AND
tblTemp1.Name = tblTemp2.Name;

UPDATE TBLONE 
SET    TBLONE.TYPE = (SELECT TBLTEMP1.TYPE 
                      FROM   TBLTEMP1 
                             INNER JOIN TBLTEMP2 
                                     ON TBLTEMP1.NAME = TBLTEMP2.NAME 
                      WHERE  TBLONE.ID = TBLTEMP2.ID); 

FF我们只需要更新满足一个条件
然后将这部分添加到该语句中 WHERE条件//WHERE子句是可选的