Listing 1: Query to Retrieve Customer Order List
SELECT CompanyName, OrderDate, Quantity, ProductName
FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID
               JOIN [Order Details] AS Item ON Orders.OrderID = Item.OrderID
               JOIN Products ON Item.ProductID = Products.ProductID
WHERE Customers.CustomerID = 'CENTC'
ORDER BY Customers.CustomerID, OrderDate, Products.ProductID
FOR XML Auto