title: Complex SQL Query with Dead Ends and 7 Tables
body: <p>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.</p>
  <p><a href="https://i.stack.imgur.com/jSMr5.jpg" rel="nofollow noreferrer">SQL Diagram</a>
  <a href="https://i.stack.imgur.com/OHod9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OHod9.png" alt="enter image description here" /></a></p>