Problem with sql

["x asasaxax" <xanaruto@xxxxxxxxx>]

Hi everyone,

   I have two tables:

table_1: product_code, atualization_date
table_2: id, date, value

I need to get the  value of table 2 that has the greatest date that is minor that atualization_date.

The select should return something like that:
unique product_code´s, with their atualization_date and their value

Did anyone knows how to solve this problem?

Thanks a lot.