Re: SQL: Working with huge tables of chronological data

On Apr 6, 5:11 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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)

Both are correct. This Chronology table doesn't exist but can be created if needed to have the results.

Thanks,
John Received on Wed Apr 11 2007 - 16:41:34 CDT