inner join and limit

Поиск
Список
Период
Сортировка
От Michele Petrazzo - Unipex
Тема inner join and limit
Дата
Msg-id 4BFD5BC0.90900@unipex.it
обсуждение исходный текст
Ответы Re: inner join and limit  (Rolando Edwards <redwards@logicworks.net>)
Re: inner join and limit  ("Luigi Antognini" <luigi370@produs.ch>)
Re: inner join and limit  (Rolando Edwards <redwards@logicworks.net>)
Re: inner join and limit  (msi77 <msi77@yandex.ru>)
Список 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 по дате отправления:

Предыдущее
От: Tim Landscheidt
Дата:
Сообщение: Re: safely exchanging primary keys?
Следующее
От: Ben Morrow
Дата:
Сообщение: Rules and sequences