Re: sql SUM and EXIST function

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Joel

Your outer SELECT does not have a GROUP BY - not sure that would fix 
anything, but it'd eliminate one error message, at least.

i suspect you want the GROUP BY taken out of the inner SELECT - there's 
almost no reason to have it there, since an EXISTS could care less (you 
don't have a HAVING clause to further define the selectivity). And 
certainly the aggregate functions have no bearing on the EXISTS - in 
fact, the inner SELECT could be

select 1 from...

and work just as well.

HTH
Vern

On 3/29/2013 11:28 AM, Stone, Joel wrote:
> How can I display the "sum(AFNLAPL),sum(AESTAPL) "  ?
>
> I am trying to aggregate all the child record qty's into one field and list them as a parent field?
>
> Thanks
>
>
>
>
> select ACNTNMB,AFNLAPL,sum(AFNLAPL),sum(AESTAPL)
>
>   from jstone/conterms a where exists (
> select acntnmb,sum(AFNLAPL),sum(AESTAPL) from jstone/applsjct b
>
> where ACNTNMB < 300000
> and a.ACNTNMB = b.ACNTNMB
> and a.ADVSNCD = b.ADVSNCD
> group by ACNTNMB
> )
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________