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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-19 : 10:53:12
|
| Aaron writes "I have a table which contains a sports schedule:team1_id,team2_id,result1,result2result1 is for team1_idresult2 is for team2_idI want to run a query to get summarize the two id fields with their assoiciated results:For Example the dataset might look like this:row 1 - id1=20,id2=30,result1=1,result2=3row 2 - id1=30,id2=20,result1=2,result2=2row 3 - id1=20,id2=40,result1=3,result2=1row 4 - id1=40,id2=20,result1=1,result2=3how do I build the query to merge the ids and thier respective results into one countable dataset" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
|
|
summary query 