Hi All,
The following SQL Statement is for a football league table which is generated from a fixtures table.
Now I have a problem with this if I need to manually alter points for a certain club (say if they have been deducted 5 points).
I have created another table called tblPointsAdjust which stores the teamID and the amount of points deducted.
Now is it possible to have this table adjust the points after the following SQL statement has been executed.
Go to the complete details ...