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 TransactSQL
operator to display rows that exist in both tables.
Which TransactSQL
operator should you insert in line 03?
A.
UNION
B.
EXCEPT
C.
UNION ALL
D.
INTERSECT