Hi people. 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 IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP (int) IDTURN (int) a table MATCH IDMATCH (int) IDGROUP (int) IDHOMETEAM (int) GOLHOMETEAM (int) and i've another table TRAINER_TEAM IDTRAINER (int) IDTEAM (int) IDTURN_FROM (int) IDTURN_TO (int) 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! -- View this message in context: http://www.nabble.com/How-can-solve-this-query--tp17455534p17455534.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]