Complex SQL Query with Dead Ends and 7 Tables

I was tasked with creating a complex query that incudes all of the data from all of the tables minus the Keys. I am having an issue with the dead end tables and how to circle back around to include the data of the connecting table. I need to select columns DivisionName, ProgramName, ProgramChairFName, ProgramChairLName, CourseID, OutcomeDescription from the listed tables.

SQL Diagram

https://stackoverflow.com/questions/66701595/complex-sql-query-with-dead-ends-and-7-tables March 19, 2021 at 10:04AM