Basketball Ladder Query

[MrBLT]

hello all
i just recently completed my tables through the help of the tables forum and now posting my first query problem. I am working on a basketball database and have the following tables

game
gameid(pk)
hometeam
awayteam
date
venueid
homeline(gambling term)
awayline

score
gameid
periodid
score

stats
gameid
teamid
fgm
fga
ftm
fta
3ptm
3pta
offreb
defreb
assist
steal
t/o
block
fouls

team
teamid(pk)
team

venue
venueid(pk)
venue

period
periodid(pk)
period

So far i have been able to generate simple queries such as percentage and sums but i want to generate a query that works out the win/loss of each team or ladder. Can anyone help because i have absolutely no idea on how to begin
Thanks

 

[WayneRyan]

MrBLT,

If you post your db, there is a better chance of getting a response. Its too much work to create tables etc. to research
your problem.

Wayne