AnsweredAssumed Answered

Sports League stats

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

Title

Sports League stats

Post

     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

Outcomes