MySQL Join and active record issue (tables have same named fields)

[eluser]charlieD[/eluser]
I had this issue yesterday - what I had to do was use the AS keyword:

$this->db->select('users.aol AS usersAOL, 'clients.aol AS clientsAOL');
$this->db->from('users');
etc...