
[pName], the
student's name.
PARAMETERS pName Text;
SELECT DISTINCTROW Classes.ClassName, Classes.Instructor
FROM Students
INNER JOIN (Classes
INNER JOIN StudentsAndClasses
ON Classes.ClassID = StudentsAndClasses.ClassID)
ON Students.StudentID = StudentsAndClasses.StudentID
WHERE ((Students.Name=[pName]));
