I just got through database design and have started entering some of our data that we track.



I would like to create something we call an event report that would be a report with:

Rank-Team Name-City-State-Wins-Losses-Runs Scored-Runs Allowed-Points

Here is the table that appears to be the place where the heavy lifting will occur.

TRID TournamentID GameID Day Field Time Team1ID T1Score Team2ID T2Score
1 1 1 Saturday M 11:00AM 12 9 10 18
2 1 2 Saturday C 11:00AM 13 13 11 7
3 1 3 Saturday H 1:10PM 10 18 11 9
4 1 4 Saturday C 1:10PM 12 8 13 6
5 1 5 Saturday H 2:15PM 11 7 12 2
6 1 6 Saturday H 3:20PM 10 6 11 8
7 1 7 Saturday H 4:25PM 11 13 10 19

How can I examine the scores and then attribute a win/loss/runs scored/runs allowed back to the teams?