Re: [SQL] JOIN

Поиск
Список
Период
Сортировка
От Loredana Curugiu
Тема Re: [SQL] JOIN
Дата
Msg-id 1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] JOIN  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
Список pgsql-novice


On 6/5/07, Oliveiros Cristina <oliveiros.cristina@marktest.pt> wrote:
Hello again, Loredana.
 
 
Additional information required :-)
 
imagine the following situation
 
1| LIA | recv1 | date1 | (date1,date2)
2|LIA | recv1 |date 1 | (date2,date3)
3| LIA | recv1 | date1 | (date1,date3)
 
 
Should this yield 6? Or 4?
date 1 is not on the second dates column, but it is on the remaining two

if the first column is count then the sum(count) should be 4.


Loredana

В списке pgsql-novice по дате отправления: