When would you use the SQL RIGHT JOIN command?
A)to find unique field values
B)to find matching records from three or more tables
C)to find orphan records
D)to find null values

Question

Quizplus · Accepted Answer

RIGHT JOIN in SQL is used to return all records from the right table, and the matched records from the left table. If there is no match, the result is NULL on the side of the left table. This can effectively be used to find orphan records in the right table that do not have corresponding matches in the left table.

When Would You Use the SQL RIGHT JOIN Command