"JOIN"附近语法错误,简单的,快啊,立即给分
UPDATE Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
WHERE Inform_Person.InformID = 78
"JOIN "附近语法错误
[解决办法]
UPDATE Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
SET Inform_Person.TechTitle = 所有评委表.TechTitle
WHERE Inform_Person.InformID = 78
update 不能对这样的结果集进行更新的
[解决办法]
不能这样做啊
[解决办法]
--try
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
[解决办法]
update a
SET a.TechTitle = b.TechTitle
from Inform_Person a,所有评委表 b
where a.UserSerial =b.EXPER_NUM
[解决办法]
--JOIN放錯位置了
UPDATE Inform_Person
SET Inform_Person.TechTitle = 所有评委表.TechTitle
FROM Inform_Person JOIN
所有评委表 ON Inform_Person.UserSerial = 所有评委表.EXPER_NUM
WHERE Inform_Person.InformID = 78
[解决办法]
或者
UPDATE Inform_Person
SET Inform_Person.TechTitle = 所有评委表.TechTitle
FROM Inform_Person ,
所有评委表
WHERE Inform_Person.UserSerial = 所有评委表.EXPER_NUM
AND Inform_Person.InformID = 78
