You develop 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 fol

lowing requirements:

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

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

Which Transact-SQL query should you use?

A. SELECT CustomerName,

OrderDate

FROM Customers

LEFT OUTER JOIN Orders

ON Customers.CustomerID = Orders.CustomerId

B. SELECTCustomerName, OrderDate

FROM Customers

RIGHT OUTER 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

JOIN Orders

ON Customers.CustomerId = Orders.CustomerId

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