On Thu, 6 Nov 2003, John W. Holmes wrote:
> I'd still like an answer to this question. Why is there a need for a
> separate table with scores?
The log is a "snapshot" in time -- what was the "total points" at the time
of the log entry.
The score table is always the accurate current score.
>
[EMAIL PROTECTED] wrote:
On Thu, 6 Nov 2003, CPT John W. Holmes wrote:
From: "Peter Beckman" <[EMAIL PROTECTED]>
I have this data:
Table Log: appid userid points datetype
Table Score: appid userid score
I want to verify that the last entry in table log of type "x" is equal to
the sum
On Thu, 6 Nov 2003, CPT John W. Holmes wrote:
> From: "Peter Beckman" <[EMAIL PROTECTED]>
>
> > I have this data:
> >
> > Table Log: appid userid points datetype
> > Table Score: appid userid score
> >
> > I want to verify that the last entry in table log of type "x" is equal to
> >
From: "Peter Beckman" <[EMAIL PROTECTED]>
> I have this data:
>
> Table Log: appid userid points datetype
> Table Score: appid userid score
>
> I want to verify that the last entry in table log of type "x" is equal to
> the sum of the scores in table score for the same appid and us
