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
Isn’t it the self join a special kind of inner join? I would say the correct answer is A.
is left join because if u use a inner join, only employees that has manager will be show, and you need all the employees including the managers
I think the correct is C. But the command question can make dubt because it doesnt say if null values in manager column ca be inclouded.