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
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
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