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 |
|
CrEsT
Starting Member
1 Post |
 Posted - 2010-06-09 : 23:16:02
|
Hi guys,I'm learning basic SQL. I have a query I can't solve. I need a query to list the match ID, venue, name of the home team, score of the home team, name of the away team, score of the away team and name of the winner for each match. Sort the results by match ID in ascending order. A portion of the expected output is shown below. (You may use more than one query) Expected output TEAM table Team_stat table Any help will be appreciated... thanks! |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-10 : 01:54:56
|
| What is relation between Team_stat table and TEAM table?Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
|
|
|
Help with Query! **Learner***