统计每个班每门课程的平均成绩
zj523 2008-05-15 07:35:03 有张student表(Id,stuName,...,classNum班号)
scorce表(Id,kcNum课程号,cj成绩)
现在要统计每个班每门课程的平均成绩,我写SQL语句如下:
select classNum as 班级,kcNum as 课程号,avg(cj) as 平均分 from scorce as A
inner join student B on A.Id=B.Id
group by (A.classNum,B.kcNum)
在SQLServer2000中运行,报错Incorrect syntax near ','
请问各位错在哪里,正确的SQL语句怎么写?