如題：自學SQL server，根據select陳述句撰寫update陳述句，為什么select陳述句正確，update陳述句報錯？
select *
from SC inner join (select C#,AVG(Score) Score_avg from SC
where C# in (select C# from Teacher,course where Course.T#=Teacher.T# and Teacher.Tname='葉平')
group by C#) av
on av.C#=sc.C#
update SC inner join (select C#,AVG(Score) Score_avg from SC
where C# in (select C# from Teacher,course where Course.T#=Teacher.T# and Teacher.Tname='葉平')
group by C#) av
on av.C#=sc.C#
set SC.Score = av.Score_avg
uj5u.com熱心網友回復：
不要老思考自己為什么錯誤，先看正確的是什么樣的。update 后面只能接具體的表名或別名。
set 只能緊接 update.
UPDATE SC
SET SC.Score = av.Score_avg
FROM SC
INNER JOIN (
SELECT C#,
AVG(Score) Score_avg
FROM SC
WHERE C# IN (SELECT C#
FROM Teacher,
course
WHERE Course.T# = Teacher.T#
AND Teacher.Tname = '葉平')
GROUP BY
C#
) av
ON av.C# = sc.C#
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/269314.html
標籤：基礎類
上一篇：h橋級聯型有原始碼波器