This is my first thread, i hope you can help me.
I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question:
I've a table TURN with this field
another table GROUP
a table MATCH
and i've another table TRAINER_TEAM
in this table i've an ID for the trainer, the id of team and the duration of the experience of this trainer with this team. The duration is set up by an IDTURN_FROM and an IDTURN_TO.
i'll want to
SELECT SUM OF GOLHOMETEAM FROM MATCH TABLE WHERE TRAINER_TEAM.IDTEAM = MATCH.IDHOMETEAM AND MATCH.IDGROUP.IDTURN.SORT >= TRAINER_TEAM.IDTURN_FROM.SORT AND MATCH.IDGROUP.IDTURN.SORT <= TRAINER_TEAM.IDTURN_TO.SORT AND TRAINER_TEAM.IDTRAINER=5
i hope is understandable.
please help, is important!!
thank u danyweb!