Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lstephan
Starting Member
12 Posts |
 Posted - 2011-09-27 : 10:01:42
|
| Hi,I would like to generate a table league (football) from a table named matches.I ve got thos fields in this table:match_date (date og match) (date)matchpart1 (id home team) (numeric)matchpart2 (id away team) (numeric)matchpart1_result (score home team) (numeric)matchpart2_result (score away team) (numeric)round_id (round) (numeric)For match won ( 3pts) equality (1pt) lost (0pt) by teamI ve to sum points by team and make a table league.It seems to be difficult for me but perharps simple for a SQL leader lolThanks a lot for any help |
|
|
|
|
|
Create a League table for Football(soccer)