I have this data:

    Table Log: appid   userid points  date    type
    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 selecting the correct (most
recent) row in log in which to match the score.

Basically I want a report of AppID, TeamMemberID, log.points, score.score
that shows where points != score;

Peter Beckman                              Director of Internet Initiatives
North American Management                            http://www.nambco.com/
703.683.0292 x239                                        [EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to