How would I write this query? Combining 3 table to as one?
I have 3 tables
1 courses ((pk)CoursId, Name, Date) All are single rows of data
2 courseInstructors ((pk)courseInstructors(fk)CourseID,IndtructorID) returns multiples instructors for each course
3 instructor (pk)instructorID, instructorName)
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.