title: Getting error code 1054 when running sub query
body: <p>I'm trying to get the user with oldest account created using this:</p>
  <pre><code>SELECT a.ID
       , a.username 
    FROM users a 
    JOIN 
       ( SELECT MAX(date_created) 
          FROM other_info
       ) b 
      ON a.ID = b.ID; 
  </code></pre>
  <p>It's returning the following; `Error Code: 1054.</p>
  <p>Unknown column 'b.ID' in 'on clause'`</p>
  <p>I've looked though the [mysql-error-1054] tag and haven't been able to find a solution, I'm not even sure which part of the query is wrong.</p>
  <p>Thanks.</p>