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



Leave a Reply 2

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