麻烦大家,我现在就是要求出具体学生某一学年获得所有的课外活动的成绩,attend(课外活动表)attend_grade是获得的学分,student_attend(学生参加课外活动表)attednd_date是时间,student是学生表,谢谢.

select c.student_id,c.student_name,m.学年,m.成绩 from student c inner join
(select b.student_id,datepart(year,b.attend_date) 学年,sum(c.attend_grade) as 成绩 from attend a inner join student_attend b
on a.attend_id=b.attend_id group by b.student_id,datepart(year,b.attend_date)) m
on c.student_id=m.student_id

试一下创建一个存储过程
create proc AttendGrade
@Attend_date as nvarchar(50),@Student_name as nvarchar(50)
as
select attend_name as 课外活动名称,attend_grade as 成绩 from attend where attend_id=(select attend_id from student_attend where student_date=@Attend_date and student_id=(select student_id from student where student_name=@Student_name))


我也是初学的，不知道对不对，试试喽
不对别骂我

呵呵,谢谢