Results 1 to 19 of 19
Thread: Need help on SQL query
Mar 22, 2010, 20:05 #1
- Join Date
- Mar 2010
- 0 Post(s)
- 0 Thread(s)
Need help on SQL query
I'm a newbie in databases and SQL worl. I have a problem. I've spent 12 hours but couldn't find the solution.
Can anyone give me a sample code, or show me the right direction please?
Here is the scenario:
I will need to find out the number of goals a player has scored in year 2009, and display various information about him such as name, shirt no etc.
The only part I couldn't figure out is the bit where I have to add all the goals scored by a certain player, and display his name, position, total number of goals scored in 2009, and shirt no.
I will be grateful if anyone can help me on this, otherwise I'm going to go mad.