inner join and limit

From: Michele Petrazzo - Unipex <michele(dot)petrazzo(at)unipex(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: inner join and limit
Date: 2010-05-26 17:34:56
Message-ID: 4BFD5BC0.90900@unipex.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi list,
I have two table that are so represented:
t1:
id int primary key
... other

t2:
id int primary key
t1id int fk(t1.id)
somedate date
... other

data t1:
1 | abcde
2 | fghi

data t2:
1 | 1 | 2010-05-23
2 | 1 | 2010-05-24
3 | 1 | 2010-05-25
4 | 2 | 2010-05-22
5 | 2 | 2010-05-26

I'm trying to create a query where the data replied are:
join t1 with t2 and return only the LIMIT 1 (or N) of the t2, with date
order (of t2).
Data should be:

t1.id | t2.id | t2,somedate
1 | 3 | 2010-05-25
2 | 5 | 2010-05-26

As said, I'm trying, but without success...
Can be done for you?

Thanks,
Michele

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ben Morrow 2010-05-26 18:16:20 Rules and sequences
Previous Message Tim Landscheidt 2010-05-25 01:22:46 Re: safely exchanging primary keys?