[eluser]ibnclaudius[/eluser]
This query:
Code:
$query = $this->db->select($this->students_grades_table . '.grade AS user_grade, ' . $this->subjects_table . '.name AS subject_name')
->from($this->students_grades_table)
->join($this->subjects_table, $this->subjects_table . '.id = ' . $this->students_grades_table . '.subject_id', 'INNER')
->join($this->classes_table, $this->classes_table . '.id = ' . $this->subjects_table . '.class_id', 'INNER')
->where(array($this->classes_table . '.school_id' => $school_id, $this->students_grades_table . '.user_id' => $user_id))
->get();
return, for example, this:
user_grade | subject_name
-------------------------
5 | Math
How can I return the subject_name even if there's no grade associated?
For example:
user_grade | subject_name
-------------------------
5 | Math
- | English
- | History
Thanks, all!