View the Exhibit and examine the structure of the LOCATIONS and DEPARTMENTS
tables. Which SET operator should be used in the blank space in the following SQL
statement to display the cities that have departments located in them? SELECT location_id,
city FROM locations SELECT location_id, city FROM locations JOIN departments
USING(location_id);
A.
MINUS
B.
INTERSECT
C.
UNION
D.
UNION ALL
Why UNION is not correct?