ahmed salah

ahmed salah

  • 1.6k
  • 530
  • 122.9k

How get data related to InstructorID from table CourseClass

Nov 29 2016 6:27 AM

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

Instructor ID

Course ID

Course table

Course ID

Course Name

CourseClass Table

Course ID

Class ID

dayname

starttime

endtime

duration

Class

Class ID

Class Name


Answers (4)