从Codeigniter中的两个以上表中获取数据

Question

here is my code of model

$this->db->select('*');
$this->db->from('vf_training_district', 'vf_training_firm', 'complain_form');
$this->db->where('complain_form.InstituteId', 'vf_training_firm.FirmId');
$this->db->where('complain_form.DistrictId', 'vf_training_district.DistrictId');
$query = $this->db->get();
return $result = $query->result_array();

getting error of unknown column complain_form.InstituteId. each and every column is same as in db

Answer 1

Hope this helps you :

 $this->db->select(*);
 $this->db->from('complain_form cf');
 $this->db->join('vf_training_firm vftf', 'vftf.FirmId = cf.InstituteId');
 $this->db->join('vf_training_district vftd', 'vftd.DistrictId = cf.DistrictId');

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

for more : https://www.codeigniter.com/user_guide/database/query_builder.html#selecting-data