$this->db->select('*'); // Select field $this->db->from('package'); // from Table1 $this->db->join('pcategory', 'package.pcategory = pcategory.id', 'INNER'); // Join table1 with table2 based on the foreign key $data['Package'] = $this->db->get(); $this->load->view('Admin/viewpackage.php', $data);