Codeigniter MySQL一个Join Query，在结果中有一个列名冲突

I have a very common, run of the mill JOIN query where I have found my self in a bit of a pickle.

My CI DB Query looks like:

    $this->db->select()
    ->from('user_event')
    ->join('game_bridge', 'user_event.gmeID = game_bridge.gmeID')
    ->where('user_event.memID', $memID);

Now what I failed to realize up until about a minute ago, is that both tables have a "location" column, however both columns contain unique sets of data to the query results I am looking for overall. With that is there a way to give one location column or the other an alias so I can access the results object for that under a different property name?

If so, how can I do that with CI's DB class/helper?

if you want to get location from both tables you have to give an alias to one or both of them keep user_event location as it just give alias to game_bridge is like game_bridge.location as game_location

$this->db->select('location,game_bridge.location as game_location')

You can set aliases in your query.

$this->db->select('user_event.location as u_loc, game_bridge.location as g_loc');

But in this case you must enumerate all fields you want to select.