Re: Trouble making formula.
Right now I could care less what the table looks like.
I want to be able to make an SQL Query work.
The more I read, the less I understand.
I have tried everything I have read, with a lot of confusion. Did what you and others have suggested about trying to come up with a query on my own, but I'm ready to reach through the internet and poke you in the eye, can you tell I'm frustrated.
Here's what I have and all I get is SYNTAX ERRORS.
Please help!!!!
SELECT a.points, b.name, dateid
FROM data a, players b
WHERE a.points BETWEEN 1 AND 7 AND dateid = max(dateid)
GROUP BY a.playersid
JOIN players b
ON a.playersid = b.playersid
GROUP BY b.name
ORDER BY a.points desc