How to get table.column in active record queries?

[eluser]Jakobud[/eluser]
Lets say I have two tables: users and roles

Each table has a column called 'id'.

If I use active record to query the values of the joined tables:

Code:

$this->db->join('role', 'role.id = user.role_id');
$query = $this->db->get('user');

foreach ( $query->result() as $row )
    echo $row->id; // <--- this is the problem right here

The 'id' that the active record query prints out is the 'id' column from the role table. But what if I want to print out the id from the user table? Is there anyway to specify it implicitly like this?

Code:

echo $row->user.id

The only alternative I've found so far is to specify what I'm selecting first:

Code:

$this->db->select('user.id AS user_id, role.id AS role_id');

But I thought perhaps there was a different way to do it with active record... Any thoughts?