title: Why are CodeIgniter Active Record and phpMyAdmin giving different results?
body: <pre><code>SELECT accounts.NameSurname, Projects.Name, personnels.NameSurname 
  FROM accounts 
  JOIN projects ON ( accounts.Id = projects.AccountId ) 
  JOIN projectpersonnels ON ( projects.Id = projectpersonnels.ProjectId ) 
  JOIN accounts AS personnels ON ( projectpersonnels.AccountId = personnels.Id )
  </code></pre>
  
  <p>results in NameSurname Name NameSurname colums</p>
  
  <hr>
  
  <p>Why would the queries above and below result in different "columns" titles and number of columns?
  I am running the query above in phpmyadmin.
  using mysql and codeigniter 1.7.3</p>
  
  <hr>
  
  <pre><code>$this-&gt;db-&gt;select('accounts.NameSurname,projects.Name,personnels.NameSurname');
  $this-&gt;db-&gt;from('accounts');
  $this-&gt;db-&gt;join('projects','accounts.Id = projects.AccountId' );
  $this-&gt;db-&gt;join('projectpersonnels','projects.Id = projectpersonnels.ProjectId');
  $this-&gt;db-&gt;join('accounts as personnels','projectpersonnels.AccountId = personnels.Id');
  $q=$this-&gt;db-&gt;get();
  </code></pre>
  
  <p>results in: NameSurname (which is personnel) Name (which is project)</p>
  
  <p>Thank you for reading and replying.</p>