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.