I have a query which I can't get my head around, it is probably simple but I have failed to find the solution.
I track debt that is attached to a member, where each member is attached to a team. If the team is due to play a report highlights the player on a "Debt Hit list". I am trying to create a report that shows players that owe but are not scheduled to play again in the near future. Here is the problem:
Each player with debt is attached to a team, some of these teams are scheduled to play and show in the calendar, the ones that are not scheduled to play do not show in the calendar (future but may have in the past). How can I select the non scheduled members.
I assume that I need a SQL Where statement but my SQL is not upto this.
Suggestions welcomed, I know I have not explained this very well. Feel free to ask questions.
I track debt that is attached to a member, where each member is attached to a team. If the team is due to play a report highlights the player on a "Debt Hit list". I am trying to create a report that shows players that owe but are not scheduled to play again in the near future. Here is the problem:
Each player with debt is attached to a team, some of these teams are scheduled to play and show in the calendar, the ones that are not scheduled to play do not show in the calendar (future but may have in the past). How can I select the non scheduled members.
I assume that I need a SQL Where statement but my SQL is not upto this.
Suggestions welcomed, I know I have not explained this very well. Feel free to ask questions.
