Select
  Stock.StockID,
  Rego,
  Make,
  Model,
  PurchaseCost,
  DatePurchased,
  DateSold,
  StockOnHandDate,
  sum(Cost.Amount)      TotalRecondCosts
 
 from Stock, Cost, ProgramSettings
 where
   Stock.StockID = Cost.StockID
 and DatePurchased < StockOnHandDate
 group by
  Stock.StockID

---

 Comments and Workarounds

---

The problem was caused by the join re-ordering, which wasn't taking into account the non-equality operators correctly. The workaround to fix this problem is to use a NOJOINOPTIMIZE clause at the end of the query statement.

---

 Resolution

---

Fixed Problem on 7/22/2001 in version 2.12 build 1