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, CrderDate
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

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