kangjane的博客

原创 多表连接查询

select class.classname,subject.subjectname,sum(score) from score join class join subject join student on class.id=student.classid and student.id=score.studentid and subject.id=score.subjectid group by