View the Exhibit and examine the data in the employees table:
You want to display all the employee names and their corresponding manager names.
Evaluate the following query:
Which join option can be used in the blank in the above query to get the required output?
A.
INNER JOIN
B.
FULL OUTER JOIN
C.
LEFT OUTER JOIN
D.
RIGHT OUTER JOIN
Explanation:
In reading, LEFT is always the first table after FROM.
And the question asked, “all employee”, which refers the first table using the alias “e”.