mardi 21 juillet 2020

Ask How write Subquery for count table in codeigniter for this query

$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