Which join option can be used in the blank in the above query to get the required output?

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?

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:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marcelo

Marcelo

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”.