Join Codeigniter

Question

Next guys, I have a vague table and other vaga_cadidato, I would like to select the data of the same when the id_entity is equal in the id_entity. However it is showing me only the data of the vacant table, I would like in this same query to show the data of the vaga_candidate. Follow my query.

function vagaDaEntidade(){
  $status = 'Aguardando Reposta';
  $id_entidade = $this->session->userdata('id_entidade');
  $this->db
  ->select("*")
  ->from("vaga")
  ->join('vaga_candidato', 'vaga.id_vaga = vaga_candidato.id_vaga')
  ->where('status_vaga', $status);


  return $query = $this->db->get()->result();
}

Hug to all.

Answer 1

Specify the tables in select. Try it this way and it will work:

$this->db
  ->select("vaga.*, vaga_candidato.*")
  ->from("vaga")
  ->join('vaga_candidato', 'vaga.id_vaga = vaga_candidato.id_vaga')
  ->where('status_vaga', $status);

That’s all!