AnsweredAssumed Answered

Sports League stats

Question asked by tomo17 on Apr 26, 2013
Latest reply on Aug 29, 2013 by chetgunhus


Sports League stats


     I have a database that collects a range of match information for teams in a league. Currently i can call up season summaries for a selected team but what I am looking to do is go a step further and get season summaries/averages for when that team has been the opponent.


     My database is currently set up with the following tables:

     Teams Table - Team ID, Team Name

     Match - MatchID, Home team IDfk, Away TeamIDfk

     Match Stats - Match IDfk, Team IDfk, stats fields


     How do I call up the matches where Team A (ie either Home team or away team) has played (this i can do) but get all of the opposition stats?


     Any suggestions greatly appreciated