Assuming that your ProductID is an IDENTITY field, so the higher the number the later the INSERT:
SELECT c.Name, p.productName FROM Customer c
JOIN (SELECT UserID, MAX(ProductID) as MaxPID FROM Purchases GROUP BY UserID) pu
ON c.UserId = pu.UserID
JOIN Purchases p
ON p.ProductID = pu.MaxPID