title: Four table join with fixed table construct
body: <p>I am trying to achieve what I think is an inner join with four tables in Oracle.  Here is the scenario:</p>
  
  <p>Tables:</p>
  
  <pre><code>Course
  Course_ID | Title
  
  Course_Offering
  Offering_ID | Location | Course_ID
  
  Attendance
  Student_ID | Offering_ID 
  
  Student
  Student_ID | Name | Number etc.
  </code></pre>
  
  <p>I am trying to write a query that will display just the <strong>student_name</strong> and <strong>title</strong> of the courses which a student has attended. A student can attend many offerings of a course which are stored in the <code>Attendance</code> table.  How would I go about accomplishing this?</p>