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 userid.
Can I do this in SQL easily? My problem is
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 userid.
Can
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 of the
[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 of
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.
Can