UPDATE Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
WHERE Inform_Person.InformID = 78"JOIN"附近语法错误
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
WHERE Inform_Person.InformID = 78"JOIN"附近语法错误
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
WHERE Inform_Person.InformID = 78update 不能对这样的结果集进行更新的
UPDATE Inform_Person
SET Inform_Person.TechTitle = 所有评委表.TechTitle
from Inform_Person
left JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
WHERE Inform_Person.InformID = 78
UPDATE Inform_Person
SET Inform_Person.TechTitle = 所有评委表.TechTitle
from Inform_Person,所有评委表
WHERE ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM and Inform_Person.InformID = 78
SET a.TechTitle = b.TechTitle
from Inform_Person a,所有评委表 b
where a.UserSerial =b.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
FROM Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
WHERE Inform_Person.InformID = 78
SET Inform_Person.TechTitle = 所有评委表.TechTitle
FROM Inform_Person ,
所有评委表
WHERE Inform_Person.UserSerial = 所有评委表.EXPER_NUM
AND Inform_Person.InformID = 78
SET Inform_Person.TechTitle = 所有评委表.TechTitle
FROM Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
WHERE Inform_Person.InformID = 78