Re: [SQL] JOIN

On 6/5/07, Oliveiros Cristina <oliveiros(dot)cristina(at)marktest(dot)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