HAVING Claus

[luvmy2kids]

Please help me figure out the correct way to write the below code:

Having SUM(ARAmount) <> 0 and Having SUM(v.InvCur) <> 0 and Having SUM(v.INV30) <>0
and Having SUM(v.INV60) and Having SUM(v.INV90) <> 0 Having and SUM(v.INV120) <> 0

Thanks!!

 

[SkipVought]

Hi,

Having SUM(ARAmount) <> 0
   and SUM(v.InvCur) <> 0
   and SUM(v.INV30) <>
   and SUM(v.INV60) <> 0
   and SUM(v.INV90) <> 0 
   and SUM(v.INV120) <> 0

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[luvmy2kids]

Okay, I tried that I received an error. Maybe I had something typed incorrectly!

 

[SkipVought]

Please post your entire SQL.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Olaf Doschke]

maybe focus a little more:

Having SUM(ARAmount) <> 0
   and SUM(v.InvCur) <> 0
   and SUM(v.INV30 ) <>    [red]<--- there is something missing here, perhaps a 0[/red]
   and SUM(v.INV60 ) <> 0
   and SUM(v.INV90 ) <> 0 
   and SUM(v.INV120) <> 0

A Having clause also is not a whole SQL statement and to make it work you need the whole SQL statement being correct.

Bye, Olaf

 

[Olaf Doschke]

in your orignal posted clause there's even not only the 0 missing....

Bye, Olaf.

 

[SkipVought]

It just might help to have a ZERO there.

What do you think?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}