How to get the last purchased product?

[Jacky Luk]

select c.CustomerID, c.FirstName, c.LastName ,   
                     p.ProductName,
                     max(o.PurchaseDateTime) As RecentVisit,
                     sum(round(od.NetSales,2)) As NetSales
 
                      from ((customers AS c LEFT JOIN orders AS o
                        ON (o.CustomerID = c.CustomerID)) LEFT JOIN
                        order_details AS od ON (o.OrderID = od.OrderID)
     			    ..... Stuck here

Product
ProductID ProductName

Customer
CustomerID FirstName LastName

Orders
OrderID, CustomerID

Order Details
OrderDetailID OrderID ProductID

[Jacky Luk]

select c.CustomerID, p.ProductName, o.PurchaseDateTime, sum(Round(od.NetSales,2))
          from customers As c 
			        INNER JOIN orders AS o ON (c.CustomerID = o.CustomerID) 
                 INNER JOIN order_details AS od ON (o.OrderID = od.OrderID)
                 INNER JOIN products AS p ON (od.ProductID = p.ProductID)
                 INNER JOIN (select c.CustomerID, max(o.PurchaseDateTime) 
					     AS lastVisit
					     from customers AS c INNER JOIN
						  orders AS o ON (c.CustomerID = o.CustomerID)
						  group by c.CustomerID) AS lastTimes
   						ON o.PurchaseDateTime = lastTimes.lastVisit
                     group by c.CustomerID

Here is the most refined version, but I can't get repeated purchased items for each order.
There is only one order item listed.

I'd like to get

Customer ID Product Name    Purchase Date    Net Sales
1                  Jade                    29-8-2013         30000000
1                  Gold Nuggets        29-8-2013          2000
2                  Jade                     29-8-2013         4000
3                  Gold Necklace       28-8-2013         3000  

[Martin Vashko]

Just adding p.ProductName and o.PurchaseDateTime to you GROUP BY clause might work.