[pClass], the
the name of the class for the list.
PARAMETERS pClass Text;
SELECT DISTINCTROW Students.Name, Students.Major
FROM Students
INNER JOIN (Classes
INNER JOIN StudentsAndClasses
ON Classes.ClassID = StudentsAndClasses.ClassID)
ON Students.StudentID = StudentsAndClasses.StudentID
WHERE ((Classes.ClassName=[pClass]));
