hello
can someone help me with this query. I want to get the averages of a football team's average kicks handballs and marks and group it by the away team. I am able to get the averages of a team as a whole but am stuck on the away team. I have two tables the game and stats. The game is as follow
GAME
gameid
date
home
away
venueid
round
time
and
STATS
gameid
teamid
kicks
handballs
marks
What do i have to do to link the teamid from stats to the away in game. Everything i have tried has been unsuccessful.
Thanks for your help
can someone help me with this query. I want to get the averages of a football team's average kicks handballs and marks and group it by the away team. I am able to get the averages of a team as a whole but am stuck on the away team. I have two tables the game and stats. The game is as follow
GAME
gameid
date
home
away
venueid
round
time
and
STATS
gameid
teamid
kicks
handballs
marks
What do i have to do to link the teamid from stats to the away in game. Everything i have tried has been unsuccessful.
Thanks for your help