WebSite Professional Server Self Test

ClassesForStudent Query

Robert B. Denny (18-Nov-95)
Database View
Used to get list of classes for a given student, by name. This query contains a parameter [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]));


WebSite Tech Support