AnsweredAssumed Answered

How to do a find to show all classes a student is NOT enrolled in?

Question asked by JohnHall7407 on Dec 18, 2010
Latest reply on Dec 19, 2010 by JohnHall7407

Title

How to do a find to show all classes a student is NOT enrolled in?

Post

Only 3 tables. Students, Classes and a join table called Enrollment

Students table has an id StudentID and Classes table has an is ClassesID. These two ids are entries in the join table to show which classes a student IS enrolled in.

We'd like to show a list of the classes that a student is NOT enrolled in also so they can add in a class that they are not currently enrolled in.

How to do a find that shows all classes a student is NOT enrolled in.

StudentsClassesTables.jpg

Outcomes