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 )

results in NameSurname Name NameSurname colums

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

$this->db->select('accounts.NameSurname,projects.Name,personnels.NameSurname');
$this->db->from('accounts');
$this->db->join('projects','accounts.Id = projects.AccountId' );
$this->db->join('projectpersonnels','projects.Id = projectpersonnels.ProjectId');
$this->db->join('accounts as personnels','projectpersonnels.AccountId = personnels.Id');
$q=$this->db->get();

results in: NameSurname (which is personnel) Name (which is project)

Thank you for reading and replying.