Set,

Good question about customer 3 and 4. I'll have to check with the
client to see what they really intend since I'm pretty sure they
thought this was a simple question to begin with!

Rick

--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

>
> To further build on your example:
>
> Customer 1
> season 1 2000
> season 2 1500
> season 3 3000
>
> Customer 2
> season 1 1500
> season 2 2000
> season 3 500
>
> Customer 3
> season 1 1200
> season 3 1700
>
> Customer 4
> season 3 2000
>
> The second/third not exists eliminates customer 3 and customer 4

from

> the result set. I assume you didn't want to return customer 3,

since

> customer 4 is a new customer, I'm more uncertain whether you want

him in

> the result set or not.
>
> HTH,
> Set