title: SQL Server 2008 - How to Join 3 tables
body: <p>SQL Server 2008:</p>
  
  <p>I have 3 tables</p>
  
  <pre><code>Users, Scores, Lessons
  </code></pre>
  
  <p><code>Users</code> &amp; <code>Scores</code> are linked by <code>StudentID</code></p>
  
  <p><code>Scores</code> &amp; <code>Lessons</code> are linked by <code>LessonID</code></p>
  
  <p>I want to display the scores for a <code>StudentID</code>. Here are the columns I want to display</p>
  
  <pre><code>Users.Name, Scores.LessonID, Scores.Result, Lessons.Title
  </code></pre>
  
  <p>I know how to Join the 2 tables. How do I throw in the 3rd table?</p>