title: MYSQL/PHP Get values from JOIN of same column name
body: <pre><code>SELECT admin.User, a.time
  
  FROM admin 
  
  LEFT JOIN a ON admin.User=a.User
  
  LEFT JOIN b ON admin.User=a.User
  </code></pre>
  
  <p>So I have three tables, admin then a &amp; b. At the moment I get tables a &amp; b by joining via a shared field called User.  However tables a &amp; b have a field called 'types' which is not in the admin table.</p>
  
  <p>What I want to do is instead of select 'types' twice - once for table a and once for table b, is have the 'types' field combined so there is only one results set for that field.</p>