MySQL JOIN

[eluser]ibnclaudius[/eluser]
I tried this:

Code:

$query = $this->db->select($this->students_grades_table . '.grade AS user_grade, ' . $this->subjects_table . '.name AS subject_name')
    ->from($this->subjects_table)
    ->join($this->students_grades_table, $this->students_grades_table . '.subject_id = ' . $this->subjects_table . '.id', 'LEFT')
    ->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();

But still returning this:

user_grade | subject_name
————————————-
5 | Math