CREATE CURSOR Sales (Customer I, Purchase D, Amount Y) INSERT INTO Sales VALUES (1, {^2004/01/01}, 150) INSERT INTO Sales VALUES (1, {^2004/01/02}, 200) INSERT INTO Sales VALUES (1, {^2004/01/15}, 100) INSERT INTO Sales VALUES (2, {^2004/02/05}, 50) INSERT INTO Sales VALUES (3, {^2004/02/01}, 180) INSERT INTO Sales VALUES (3, {^2004/01/01}, 100) *!* I need a select sql that returns ONE record per customer, *!* with the max amount for each customer, and the dato of purchase of this max amount. *!* 1 2004/01/02 200 *!* 2 2004/02/05 50 *!* 3 2004/02/01 180 SELECT ; Customer, ; Purchase, ; Amount ; FROM ; Sales ; WHERE ; STR(Amount, 10) + DTOS(Purchase) IN ; (SELECT MAX(STR(Amount, 10) + DTOS(Purchase)) ; FROM Sales AS Sales1 WHERE Sales1.Customer = Sales.Customer)