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