DRAG DROP
You use Microsoft SQL Server 2012 to develop a database that has two tables named Div1Cust and
Div2Cust.
Each table has columns named DivisionID and CustomerId . None of the rows in Div1Cust exist in
Div2Cust.
You need to write a query that meets the following requirements:
The rows in Div1Cust must be combined with the rows in Div2Cust.
The result set must have columns named Division and Customer.
Duplicates must be retained.
Which three Transact-SQL statements should you use? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct order.)
Answer: 
LOL.
That answer has nothing to do with the question. Actual answer should be:
SElECT DivisioniD AS Division, CustomerID AS Customer
FROM Div1Cust
UNION ALL
SELECT DivisionID, CustomerID
FROM Div2Cust
0
0
This belongs to question 98.
0
0
You’re right
0
0
Absolutely right
0
0