List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 6 2010 11:15am
Subject:Query help
View as plain text  
Hi,

I've the following fields within a table :

fixtures_results_id
home_teams_id
away_teams_id
home_goals
away_goals
home_users_id
away_users_id

From this I want to extract the following type of information if
the home_users_id or away_users_id = 1 :

total number of games games
number of games won
number of games drawn
number of games lost
number of goals scored
number of goals conceded
biggest win
biggest loss
most goals in a game

I'd appreciate any help with regards the query and whether or not it is
possible to do ?

Cheers
Neil

Thread
Query helpTompkins Neil6 Sep
  • Re: Query helpAnanda Kumar6 Sep
    • Re: Query helpTompkins Neil6 Sep
      • Re: Query helpAnanda Kumar6 Sep
        • Re: Query helpTompkins Neil6 Sep