>I need a query to extract the most recent price inserted for a product
>i.e.
>
>

>id_product    year   price
>1             2004   12004
>1             2003   12003
>2             2003   22003
>2             2002   22002
>

>
>so as to obtain
>

>id_product    year   price
>1             2004   12004
>2             2003   22003
>

>
>
>Which is the SQL syntax to perform the Select?

YOu need to do this in two steps:

SELECT id_product, MAX(year) AS MostRecent ;
FROM YourTable ;
GROUP BY 1 ;
INTO CURSOR Recent

SELECT id_product, Year, Price ;
FROM YourTable ;
JOIN Recent ;
ON YourTable.id_product = Recent.Id_product ;
AND YourTable.Year = Recent.MostRecent ;
INTO CURSOR Result

Tamar