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
这是我写的，为什么呢，谢谢啦
所有這些 SUM(前面都要加 select
按时上课=(SELECT SUM(startclass) FROM Tab_Check GROUP BY [name],checkdate),
update就不要用from了
你的所以sum函数处都有语法错误，少了"select"
sum前都少了select了
谢谢各位了，但是我改完之后又出现 关键字 'ORDER' 附近有语法错误。，麻烦各位了