Welcome Guest, Not a member yet? Register   Sign In
Inserting a Subquery in a Join using Query Builder
#1

(This post was last modified: 06-02-2023, 02:52 AM by mikboor09.)

Hello, i need to do this query where i get the courses that a specific student doesn't have:

Code:
SELECT students_courses.*, courses.*
FROM courses
LEFT JOIN (
    SELECT student_id, course_id
    FROM students_courses
    WHERE student_id = 296
) students_courses ON courses.id = students_courses.course_id
WHERE students_courses.student_id IS NULL

I'm trying to do it in query builder but I can't get it to work. Does anyone know to do it or maybe in another way?

PHP Code:
$builder $this->model->db->table('students_courses');
        
$subQuery 
$builder->select('student_id, course_id')
                  ->where('student_id'$studentId)
                  ->getCompiledSelect();

$query $this->model->select('students_courses.*, courses.*')
                    ->join('(' $subQuery ')' 'students_courses''courses.id = students_courses.course_id''left')
                    ->where('students_courses.student_id'null)
                    ->get(); 
Reply


Messages In This Thread
Inserting a Subquery in a Join using Query Builder - by mikboor09 - 05-31-2023, 05:19 PM



Theme © iAndrew 2016 - Forum software by © MyBB