Alias, how?

[eluser]Asinox[/eluser]
Hi, im trying to make a JOIN but i hav a field with the same name in both tables, how i ll make a ALIAS for 1 field?

Code:

function listar_subcategorias(){
        $this->db->select('*');
        $this->db->from('subcategories');
        $this->db->join('categories','categories_id=subcategories.category_id');
        $query = $this->db->get();
        return $query->row_result();
}

Thanks