SELECT Student.MajorID, Student.State, Student.EntryYear, Class.Semester, Enrollment.MidtermGrade, Enrollment.FinalGrade, Course.Department, Course.Credits, Student.Gender, Student.USResident, Course.MPCategory, Course.Technical
FROM (Major INNER JOIN Student ON Major.MajorID = Student.MajorID) INNER JOIN (Course INNER JOIN (Class INNER JOIN Enrollment ON Class.ClassID = Enrollment.ClassID) ON Course.CourseID = Class.CourseID) ON Student.StudentID = Enrollment.StudentID
WHERE (((Class.Semester) Like [EntryYear] & "*"));
上面那一大堆没什么意思,就是从一堆表中选出某几列,最后的结果是筛选出了每年的新生在大一的期中和期末各科成绩,例如2003年入学的新生在2003春季班+2003秋季班,这一整学年的期中和期末的各科成绩。
问题出现在最后的这个条件句,为什么将Semester 与EntryYear设为相似就可以筛选出当年的新生在当年的全部学习成绩,而不会将其他年份入学的人混在一起?
WHERE (((Class.Semester) Like [EntryYear] & "*"));还有,这个语句后面的 ([EntryYear] & "*")是什么意思??
|