muskee Posted October 3, 2016 Share Posted October 3, 2016 Hi guys, Please help! So I have 3 tables, Student --< Enrollment >---- Course I would like to search for the students that haven't enrolled on a certain course. For example I have this course: Id Name Credtis 202 Artificial Intelligence 4 In the enrollments table I can see everyone that has taken this course, How can I search for the people that haven't taken this course? Link to comment Share on other sites More sharing options...
webko Posted October 3, 2016 Share Posted October 3, 2016 You could Go To Related records from Course to Enrolment to get who has taken it, and then Find Omitted.... to show the one's who haven't... 1 Link to comment Share on other sites More sharing options...
muskee Posted October 3, 2016 Author Share Posted October 3, 2016 Yeah that seems to work, thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2759 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now