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 |
|
astrojason
Starting Member
4 Posts |
 Posted - 2009-09-06 : 05:49:39
|
| Done thanks :D I didn't want to get in trouble for askign for help online so i thought it would be better to delete what i can. Seriously.. you guys/girls... are the best :) |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-06 : 08:53:29
|
quote:
I have always wanted to learn but this html assignment is hard enough without a SQL requirement
Work (and life in general) is similar to school in that way. Stuff you have to do keeps getting in the way of stuff you want to do. Better get used to it now.  Give it a try and post you what come up with.Be One with the OptimizerTG |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-06 : 12:00:55
|
Oh - you talk about MYSQL?This is an MS SQL Server forum so the solution might look very different.I know that in MYSQL the use of subqueries isn't possible in all versions...Have a look here for MYSQL:http://www.dbforums.com/
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-06 : 21:38:42
|
| Can't you do any part of this question? ie: "A list of dogs..." That is just a simple SELECT out of one table (<hint>: the dog table)."...that have career winnings..."That will involve JOINing the [Entry] and [Prize] tables to the [Dog] table and using a GROUP BY on the dog name or id with a SUM function used to get the total winnings for each dog.That will get you half way there. I'll say again, I"m happy to help but I would like to see some attempted effort on your part.Be One with the OptimizerTG |
|
|
|
|
|
|
New to SQL and have a question i need help with :)