public function getdata() { $this->db->select('*'); $this->db->from('table1'); // this is first table name $this->db->join('table2', 'table2.id = table1.id'); // this is second table name with both table ids $query = $this->db->get(); return $query->result(); }

how to use join query in codeigniter

Similar Code Examples