title: Inner Joining three tables
body: <p>I have three tables I wish to inner join by a common column between them.</p>
  
  <p>Say my tables are;</p>
  
  <pre><code>TableA TableB TableC
  </code></pre>
  
  <p>I wish to join <code>A-B</code>, but then also <code>B-C</code> all by this common field I will call common.</p>
  
  <p>I have joined two tables like this;</p>
  
  <pre><code>dbo.tableA AS A INNER JOIN dbo.TableB AS B
  ON A.common = B.common
  </code></pre>
  
  <p>How do I add the third one?</p>