Hi All,
I have a database and need to create a query that will pull information from 3 tables.
Table Name Description
1 - courses: contains list of courses and their (course) levels
2 - Students: contains list of students and their training levels
3 - TrainingRecord: contains list of courses completed by each student and completion status.
The biggie here is I only want to know which courses a student needs to take based on their training level.
Thanks
I have a database and need to create a query that will pull information from 3 tables.
Table Name Description
1 - courses: contains list of courses and their (course) levels
2 - Students: contains list of students and their training levels
3 - TrainingRecord: contains list of courses completed by each student and completion status.
The biggie here is I only want to know which courses a student needs to take based on their training level.
Thanks
Last edited: