title: Product with Last Purchase Date
body: <p>I would like to query from SQL Server 2000 Database.I have got two tables. They are Purchase and PurchaseDetails. I would like to get product records with Last Purchase ID but I can't query with the following statements.So please help me.</p>
  
  <pre><code>SELECT     TOP 100 PERCENT dbo.Purchase.PurchaseID AS LastOfPurchaseID,  dbo.PurchaseDetails.ProductID, 
                        MAX(dbo.Purchase.PurchaseDate) AS LastOfPurchaseDate
  FROM         dbo.Purchase INNER JOIN
                        dbo.PurchaseDetails ON dbo.Purchase.PurchaseID = dbo.PurchaseDetails.PurchaseID 
  GROUP BY dbo.PurchaseDetails.ProductID, dbo.Purchase.PurchaseDate,dbo.Purchase.PurchaseID
  ORDER BY MAX(dbo.Purchase.PurchaseDate) DESC
  </code></pre>