DropClass Query

Robert B. Denny (18-Nov-95)
Database View
Used to drop a student from a class, by name. This query contains a parameter [pName], the student's name.
PARAMETERS pName Text, pClass Text;
DELETE DISTINCTROW StudentsAndClasses.*, Classes.ClassName, Students.Name
FROM Students 
    INNER JOIN (Classes 
        INNER JOIN StudentsAndClasses 
        ON Classes.ClassID = StudentsAndClasses.ClassID) 
    ON Students.StudentID = StudentsAndClasses.StudentID
WHERE ((Classes.ClassName=[pClass]) 
    AND (Students.Name=[pName]));

WebSite Tech Support