[eluser]123wesweat[/eluser]
Code:
$this->db->from('tableA');
$this->db->join('tableA', 'tableA.id = tableB.nameID');
$this->db->where('user_id', $user_id);
return $this->db->get();
But i have an field name id in both tables, how do i get both of this id's??
At the moment i have
Code:
$res = $this->db_model->get_profile($user_id)->result
$res->id just gives the id of tableA.
How do i get tableB.id???