sql help, please

[quilaho]

ok ... i'm developing a report utilizing sql. i have some sum functions that i'm using. if i have these straight in the select clause everything works. as soon as i use them in a subselect or in the having clause it errors out. if anyone can tell me why this does not work, it would be greatly appreciated. the code and error message is in the code section below. does anyone know why i cannot use these sums in a subselect???

---

Code

[Guest.Visitor]

quilaho wrote: > ok ... i'm developing a report utilizing sql. i have some sum > functions that i'm using. if i have these straight in the select > clause everything works. as soon as i use them in a subselect or in > the having clause it errors out. This error can be kind of tricky to solve at times but first: Are you sure the first statement is complete? I see no Group By clause and that should cause an error. First thing I would try on your second statement is to reverse the Having statement. Hopefully it will do the >0 check first if you specify it first. If that doesn't work, reply back and I'll give you another possibility at a solution using the "With" clause. Bill