$this->db_database2->select('province_id, province_title, COUNT(kua_id) as jumlah_kua');
$this->db_database2->from('master_kua');
$this->db_database2->join('iapi_province', 'iapi_province.province_id = master_kua.kua_province_id');
$this->db_database2->join('iapi_pegawai', 'iapi_pegawai.pegawai_province = master_kua.kua_province_id');
$this->db_database2->group_by('province_id');
return $this->db_database2->get()->result_array();
Aucun commentaire:
Enregistrer un commentaire