Which type of join between DEPARTMENTS and LOCATIONS tables would produce this information as part of its output?

View the Exhibit and examine the table structure of DEPARTMENTS and LOCATIONS tables. You want to display all the cities that have no departments and the departments that have not been allocated cities. Which type of join between DEPARTMENTS and LOCATIONS tables would produce this information as part of its output?

View the Exhibit and examine the table structure of DEPARTMENTS and LOCATIONS tables.

You want to display all the cities that have no departments and the departments that have not been allocated cities.

Which type of join between DEPARTMENTS and LOCATIONS tables would produce this information as part of its output?

A.
NATURAL JOIN

B.
FULL OUTER JOIN

C.
LEFT OUTER JOIN

D.
RIGHT OUTER JOIN



Leave a Reply 1

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


User

User

Select … From … A Full outer join B where a.id is null or b.id is null;