Search results

  1. C

    Count number of wins, draws, etc for a team

    I have t_results tables that is as follows: t_results match_id date hometeam (t_teams.teamname lookup) awayteam (t_teams.teamname lookup) winner (t_teams.teamname lookup) I am trying to produce a summary of stats for each team e.g. wins, draws, losses, home wins, home draw, home losses for...
  2. C

    Changing table(s) structure

    Hi, I have been provided a table of sport fixtures (and results) that has the following structure: t_fixtures ID HomeTeam AwayTeam Official (various other fixture stats but unique to each fixture) To my understanding of database design it is better if I had three tables, t_fixture, t_teams...
Back
Top Bottom