Which Transact-SQL query should you use?

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders.

The tables are related by a column named CustomerID.

You need to create a query that meets the following requirements:

• Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.

• Results must include customers who have not placed any orders.

Which Transact-SQL query should you use?
A . SELECT CustomerName, OrderDate
FROM Customers
RIGHT OUTER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
B . SELECT CustomerName, OrderDate
FROM Customers
JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
C . SELECT CustomerName, OrderDate
FROM Customers
CROSS JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
D . SELECT CustomerName, OrderDate
FROM Customers
LEFT OUTER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID

View Answer

Answer: D

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms177634.aspx