Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] JOIN - Mailing list pgsql-novice

From Loredana Curugiu
Subject Re: [SQL] JOIN
Date
Msg-id 1c23c8e70706050757r212f0369oaee3909598ce7097@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] JOIN  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-novice
Tree view


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 by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: [SQL] JOIN
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: [SQL] JOIN