I've always thought that the easiest way to combat this particular problem is simply to ensure that a single person may not appear more than once in any given table. Or more than once in all three tables (by adding a 'AND NOT IN (...)' clause to the subsequent week/month/year queries).