You have two tables named Products and NewProducts that have identical structures. You have the following query (Line numbers are included for reference only):
01 SELECT Product, Description
02 FROM dbo.Products
03 ……..
04 SELECT Product, Description
05 FROM dbo.NewProducts
You need to choose the appropriate Transact-SQL operator to display rows that exist in both tables.
Which Transact-SQL operator should you insert in line 03?
A.
UNION
B.
EXCEPT
C.
UNION ALL
D.
INTERSECT