Question

vfp中显示group by 语句缺少或无效

SELECT Student.sno,Student.sname, Course.cno, Course.cname,;
AVG(sc.score) as 平均成绩;
FROM 学生管理!course INNER JOIN 学生管理!sc;
INNER JOIN 教学管理!student ;
ON Student.sno = sc.sno ;
ON Course.cno = sc.cno;
WHERE Student.sname LIKE "李%";
ORDER BY Course.cno
我有教学管理表，没有学生管理表

Answer 1

可以改为:
SELECT Student.sno,Student.sname, Course.cno, Course.cname,;
AVG(sc.score) as 平均成绩;
FROM 学生管理!course
INNER JOIN 学生管理!sc ON Course.cno = sc.cno;
INNER JOIN 教学管理!student ON Student.sno = sc.sno ;
WHERE Student.sname LIKE "李%";
Group by Student.sno,Student.sname, Course.cno, Course.cname;
ORDER BY Course.cno