Re: SQL: Working with huge tables of chronological data

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 06 Apr 2007 14:11:31 -0700
Message-ID: <1175893886.831793@bubbleator.drizzle.com>

John wrote:
> 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

Let me repeat my question by way of an example. Which is correct?

Chronology

(03:50pm, A1)
(03:51pm, B1)
(03:55pm, A2)
(03:55pm, B2)
(03:56pm, B3)

or

Chronology

(03:50pm, A1)
(03:51pm, B1)
(03:55pm, B2)
(03:55pm, A2)
(03:56pm, B3)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Apr 06 2007 - 16:11:31 CDT