Thread: Problem with sql
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.
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.
On Tue, Oct 28, 2008 at 11:36:12PM -0300, x asasaxax wrote: > 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 select t1.*, (select t2.value from table_2 as t2 where t2.date < t1.atualization_date order by t2.date desc limit 1) from table_1 as t1 ; depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007