SQL2005 同时更新多列SUM,显示关键字 'FROM' 附近有语法错误。

Question

UPDATE Tab_Checksum
SET 姓名=[name],
考勤日期=checkdate,
按时上课=(SUM(startclass)
FROM Tab_Check
GROUP BY [name],checkdate),
按时下课=(SUM(finishclass)
FROM Tab_Check
GROUP BY [name],checkdate),
迟到=(SUM(later)
FROM Tab_Check
GROUP BY [name],checkdate),
旷课=(SUM(absenteeism)
FROM Tab_Check
GROUP BY [name],checkdate),
早退=(SUM(startclass)-SUM(finishclass)
FROM Tab_Check
GROUP BY [name],checkdate),)

ORDER BY[name],checkdate
这是我写的，为什么呢，谢谢啦

Answer 1

所有這些 SUM(前面都要加 select
按时上课=(SELECT SUM(startclass) FROM Tab_Check GROUP BY [name],checkdate),