Hi David,

Glad to be of help. :)

>Sergey,
>
>>Try

SELECT id_product, year, price ;
>>	FROM mytable mt1 ;
>>	WHERE year IN ( SELECT MAX(year) FROM mytable mt2
>>			 WHERE mt2.id_product = mt1.id_product )
>>

>
>Bingo! That's the correlated subquery I was trying to remember.