[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]));