title: Joining 3 tables in SQL and displaying columns from each
body: <p>I have three tables that all share a common ID and I wish to display columns from each of these tables by joining based on this common ID.</p>
  
  <p>I am able to join two of the three tables but when I include the third I get errors.</p>
  
  <p>This is my script:</p>
  
  <pre><code>select TableA.CommonID, TableA.Column1, TableB.Column2, TableC.Column3
  from TableA
  join TableB on TableA.CommonID = TableB.CommonID
  join TableC on TableA.CommonID = TableC.CommonID;
  </code></pre>
  
  <p>What Am I doing wrong?</p>