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)