Join in CodeIgniter

PHP

public function vp_patients(){ $this->db->select('b.*'); $this->db->from($this->table . ' as a'); $this->db->join('_patient as b', 'b.CHART = a.patient_id'); $this->db->order_by('b.CHART', 'asc'); $query = $this->db->get(); return $query->result(); }

1 2 3 4 5 6 7 8 9

public function vp_patients(){         $this->db->select('b.*');         $this->db->from($this->table . ' as a');         $this->db->join('_patient as b', 'b.CHART = a.patient_id');         $this->db->order_by('b.CHART', 'asc');         $query = $this->db->get();           return $query->result();     }