Question

What set operator would you use if you wanted to see all of the Customers and the Employees including any records that may appear in both Customers and Employees? select firstname ,lastname ,phone from Customers select firstname ,lastname ,phone from Employees; Group of answer choices1 INTERSECT2 EXCEPT3 UNION ALL4 UNION

Answer 1

Answer:

1. INTERSECT

Explanation:

Intersection is the set operator that gives us the information which is common to both tables. In this case the query will be:

SELECT firstname, lastname, phone FROM Customers

INTERSECT

SELECT firstname, lastname, phone FROM Employees;