What is the expected result?

Consider the following SQL query:

SELECT product_id FROM supplier_A

UNION

SELECT product_id FROM supplier_B;

What is the expected result?
A . All product_id values from both tables with duplicates or repeating rows
B . All product_id values from supplier_A table but not from supplier_B table
C . All product_id values from supplier_B table but not from supplier_A table
D . All product_id values from both tables with no duplicates or repeating rows

View Answer

Answer: D