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 rowsin Div2Cust.
The result set must have columns named Division andCustomer.
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:
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms180026.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms188055.aspx
Exam D
