With a little poking and prodding I got it to work. Thanks to you both.
I have one question that has gone unanswered... I need to add the points into the calculation. Any suggestions?
On the second line of code where you are asking for TEAM, I have no field called Team, only HomeTeam and VisitorTeam. Will it still work with a field name that isn't in the table like that?
I also have not yet tested the code but will in a little while.
I am relatively new to SQL and have got a standings page to work ok if I only look at the home team... here's my sample table
ScheduleTable
DIVISION HOMETEAM VISITORTEAM HOMESCORE VISITORSCORE
A leafs blues 1 1
B wings...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.