Table t2, below, records the Date on which an Actor performs a Role.
Rules:
1. perform 1 role per date
2. perform each role before starting again
B is the next Actor in line to perform Role=1 on Date=2003-10-20
Is there a query that will select B and exclude A & C since they have
already performed role 1.
The data is simplified - there are approximately 20 roles and 60 actors
Any help would be greatly appreciated
Dave
roleID,DATES,actorID
1,2003-10-06,A
2,2003-10-06,B
3,2003-10-06,C
1,2003-10-13,C
2,2003-10-13,A
3,2003-10-13,B