[Solved] How would you modify this query to include students without enrollments?SELECT Students.name, Courses.course_name FROM Students INNER JOIN Enrollments ON Students.student_id = Enrollments.... | SQL

SQL - INNER JOIN

How would you modify this query to include students without enrollments?

SELECT Students.name, Courses.course_name FROM Students INNER JOIN Enrollments ON Students.student_id = Enrollments.student_id INNER JOIN Courses ON Enrollments.course_id = Courses.course_id;

AUse CROSS JOIN instead of INNER JOIN

BAdd WHERE clause filtering NULL enrollments

CChange second INNER JOIN to RIGHT JOIN

DChange first INNER JOIN to LEFT JOIN to include all students

Step-by-Step Solution

Solution:

Step 1: Identify requirement
Including students without enrollments means keeping all students even if no matching enrollment exists.
Step 2: Use LEFT JOIN for first join
Changing first INNER JOIN to LEFT JOIN keeps all students and matches enrollments if any.
Step 3: Evaluate other options
Add WHERE clause filtering NULL enrollments filters out NULLs, which excludes unmatched students. Change second INNER JOIN to RIGHT JOIN changes second join but does not affect students without enrollments. Use CROSS JOIN instead of INNER JOIN creates all combinations, not desired.
Final Answer:
Change first INNER JOIN to LEFT JOIN to include all students -> Option D
Quick Check:
LEFT JOIN keeps all left table rows [OK]

Quick Trick: Use LEFT JOIN to keep all rows from left table [OK]

Common Mistakes:

MISTAKES

Using INNER JOIN excludes unmatched rows
Misusing RIGHT JOIN in this context
Adding WHERE filters that remove unmatched rows

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

How would you modify this query to include students without enrollments?

Step 1: Identify requirement

Step 2: Use LEFT JOIN for first join

Step 3: Evaluate other options

Final Answer:

Quick Check:

Want More Practice?