title: Join table on earlier joined table
body: <p>Say I have got three tables: A, B and C.</p>
  
  <pre><code>A has primary key a
  B has primary key a and also a non-primary key c.
  C has primary key c.
  </code></pre>
  
  <p>I want to begin selecting from table A.</p>
  
  <p>So I got a query like this:</p>
  
  <pre><code>Select * from A join B on A.a=B.a join C on B.c=C.c
  </code></pre>
  
  <p>It returns </p>
  
  <p>Unknown column 'B.c' in 'on clause''</p>
  
  <p>Is this impossible in mysql, joining a table on a joined table? Or am I just doing something wrong? BTW table and column names a made up.</p>