R
Richard Hollenbeck
If I list the students in the students table I get 204 students. But if I
add the studentsInCourses table to the query I get 129 students. This is
because when a student is dropped from a course they are not automatically
dropped from the students table.
I tried the following but it returned zero records:
SELECT students.studentID
FROM students INNER JOIN studentsInCourses ON students.studentID =
studentsInCourses.studentID
WHERE (((students.studentID)<>[studentsInCourses].[studentID]));
add the studentsInCourses table to the query I get 129 students. This is
because when a student is dropped from a course they are not automatically
dropped from the students table.
I tried the following but it returned zero records:
SELECT students.studentID
FROM students INNER JOIN studentsInCourses ON students.studentID =
studentsInCourses.studentID
WHERE (((students.studentID)<>[studentsInCourses].[studentID]));