contestada

Suppose tables employee and customer both store address information, and you want to send a letter to all employees and customers of your company to make a major announcement. which sql keyword would you most likely use here?

Respuesta :

The choices that I found on this question are:
A) INTERSECT
B) UNION
C) UNION ALL
D) JOIN

The answer is B. Union. it combines all the needed details of the customers with their addresses, names on a table. Union ALL does not apply because in this command and similar words would be combined as one and can delete some needed information.