Problem
How to get schedule for instructor from table CourseClass Table by sql query
I have 5 table as following :
Course table has relation with Instructor table many to many and generated table Instructor Course table .
Course table has relation with Class table many to many and generated table CourseClass Table table .
Instructor table
Instructor ID
Instructor Name
Instructor Course table
Course ID
Course table
Course Name
CourseClass Table
Class ID
dayname
starttime
endtime
duration
Class
Class Name