Re: SQL: Working with huge tables of chronological data

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 06 Apr 2007 22:34:56 +0200
Message-ID: <4616AEF0.2040700@gmail.com>

John schrieb:
> On Apr 6, 12:04 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> John wrote:
>>> On Apr 5, 5:37 pm, DA Morgan <damor..._at_psoug.org> wrote:
>>>> But I take issue, at least in theory, with your response that the same
>>>> times can not occur in A and B. They are are independent ... why not?
>>> I misunderstood your question. They can occur at the same time.
>>> Thanks for helping,
>>> John
>> Which leads to the question I asked above ... then which comes first?
>> The chicken or the egg?

>
> They are in a separate tables so there is no one coming before the
> other or not.
>
> Thanks for your help,
>
> John
>

<snip>
Chronology

(03:50pm, A1)
(03:51pm, B1)
(03:55pm, A2)
(03:58pm, A3)
(03:59pm, A4)
(04:00pm, B2)

I'm looking for all the sequences of events A in the chronology with no B event in the middle. Here the results would be: (A2, A3) ; (A2, A4) and (A3, A4)

Thanks!

John
<snip>

At this point i am lost.

Best regards

Maxim Received on Fri Apr 06 2007 - 15:34:56 CDT