From: | "sdger erger" <killen(dot)nextdoor(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Why doesn't this query work? Puzzle to hard for me to crack |
Date: | 2008-02-20 15:41:11 |
Message-ID: | deb32a990802200741t28c28ae3gfcec12f690103202@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
This query works as I want it to:
SELECT sum(cutoffuohands) AS HANDS, sum(cutoffuopfr) AS pfr
FROM compiledplayerresultspositionaction
JOIN compiledresults
ON compiledplayerresultspositionaction.compiledplayer results_id =
compiledresults.compiledplayerresults_id
JOIN players
ON compiledresults.player_id = players.player_id
WHERE playername = 'Robert'
It returns the number of "cutoffuohands" and the number of "cutoffuopfr" for
the player Robert.
--------------------------------------------------------
But this similar query does not work as I want it to do:
SELECT sum(cutoffuohands) AS HANDS, sum(cutoffuopfr) AS pfr
FROM compiledplayerresultspositionaction
JOIN compiledresults
ON compiledplayerresultspositionaction.compiledplayer results_id =
compiledresults.compiledplayerresults_id
JOIN players
ON compiledresults.player_id = players.player_id
WHERE playername = 'Robert'
I want it to return all the "cutoffuohands" and "cutoffuopfr" for all
players not named Robert. But it returns unreasonable numbers.
Unfortunately I don't know much about the inner workings of the database and
unfortunately I'm only a novice with SQL so I haven't been able to figure
out how to fix the second query. I hope you guys here on the mailing list
can take a lot at this and see if you can figure it out.
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2008-02-20 16:36:08 | Re: Why doesn't this query work? Puzzle to hard for me to crack |
Previous Message | Phillip Smith | 2008-02-20 03:24:17 | Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP |