Bugs? Re: HAVING [cond...] problem

2001-06-14 Thread Cliff Daniel
Still doesn't work, I've even tried: HAVING ( Avg_Xmit = 12345 ) AND ( Samples >= 25 ) 19000 rows returned, none equalling 12345, but all have Samples >= 25. It's almost as if this became an OR. Cliff Gerald Clark <[EMAIL PROTECTED]> writes: > Have you tried: > HAVING > ( Avg_Xmit

Re: HAVING [cond...] problem

2001-06-14 Thread Gerald Clark
Have you tried: HAVING ( Avg_Xmit < 28800 ) AND ( Samples >= 10 ) ? Cliff Daniel wrote: > I'm having some difficulting on 3.23.38, linux x86... When I write > the following query the HAVING clause is only listening to the 'AND > Samples >= 10' and displas all Avg_Xmit regardless if it's le

HAVING [cond...] problem

2001-06-13 Thread Cliff Daniel
I'm having some difficulting on 3.23.38, linux x86... When I write the following query the HAVING clause is only listening to the 'AND Samples >= 10' and displas all Avg_Xmit regardless if it's less than or equal to 28800. If I remove the 'AND Samples >= 10' I get the correct results, but of cou