inner join and limit
От | Michele Petrazzo - Unipex |
---|---|
Тема | inner join and limit |
Дата | |
Msg-id | 4BFD5BC0.90900@unipex.it обсуждение исходный текст |
Ответы |
Re: inner join and limit
Re: inner join and limit Re: inner join and limit Re: inner join and limit |
Список | 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
В списке pgsql-sql по дате отправления: