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

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

Quizplus · Accepted Answer

RIGHT JOIN is used to select all the records from the right table and matching records from the left table. If there are any orphan records in the right table, they will be included in the result set with NULL values for the columns that come from the left table. Therefore, using RIGHT JOIN can help in finding orphan records.

When Would You Use the SQL RIGHT JOIN Command