Solution:Step 1: Identify right tableEnrollments is right table to keep all enrollments.Step 2: Use RIGHT JOIN with Students as left, Enrollments as rightStudents RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID is correct.Final Answer:SELECT Enrollments.Course, Students.Name FRO

[Solved] Given tables:Students:StudentID | Name1 | Anna2 | BenEnrollments:EnrollmentID | StudentID | Course1001 | 1 | Math1002 | 3 | ScienceHow can you use RIGHT JOIN to find all enrollments with student... | SQL

SQL - LEFT and RIGHT JOIN

ASELECT Enrollments.Course, Students.Name FROM Enrollments LEFT JOIN Students ON Enrollments.StudentID = Students.StudentID;

BSELECT Enrollments.Course, Students.Name FROM Enrollments RIGHT JOIN Students ON Enrollments.StudentID = Students.StudentID;

CSELECT Enrollments.Course, Students.Name FROM Students LEFT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;

DSELECT Enrollments.Course, Students.Name FROM Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;

Step-by-Step Solution

Solution:

Step 1: Identify right table
Enrollments is right table to keep all enrollments.
Step 2: Use RIGHT JOIN with Students as left, Enrollments as right
Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID is correct.
Final Answer:
SELECT Enrollments.Course, Students.Name FROM Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID; -> Option D
Quick Check:
RIGHT JOIN keeps all enrollments, unmatched students NULL = SELECT Enrollments.Course, Students.Name FROM Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID; [OK]

Quick Trick: RIGHT JOIN keeps all right table rows, unmatched left columns NULL [OK]

Common Mistakes:

MISTAKES

Swapping tables in join
Using LEFT JOIN instead of RIGHT JOIN
Incorrect ON clause columns

Master "LEFT and RIGHT 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

Given tables:

Step 1: Identify right table

Step 2: Use RIGHT JOIN with Students as left, Enrollments as right

Final Answer:

Quick Check:

Want More Practice?