Skip site navigation (1) Skip section navigation (2)

Re: Why doesn't this query work? Puzzle to hard for me to crack

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Why doesn't this query work? Puzzle to hard for me to crack
Date: 2008-02-20 16:36:08
Message-ID: 47BC56F8.5060104@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
These queries are identical!

I'm guessing your query works because there is only one player named 
Robert.  If there were more than one Robert; the query will likely also 
produce incorrect results.

IAC, try adding "GROUP BY players.player_id".




sdger erger wrote:
> 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!


In response to

pgsql-novice by date

Next:From: Frank BaxDate: 2008-02-20 16:38:42
Subject: Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP
Previous:From: sdger ergerDate: 2008-02-20 15:41:11
Subject: Why doesn't this query work? Puzzle to hard for me to crack

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group