Subject Re: [firebird-support] Re: Trouble with BETWEEN operator
Author Helen Borrie
At 08:12 PM 11/04/2008, you wrote:
>>
>> And what is the recommended/most efficient way to achieve the query
>then?
>
>Helen and Anderson, thanks for the suggestions. I think I have to do
>something along the lines Anderson suggests as the "between stuff"
>might be part of a bigger query and having the grouping in the main
>query might interfere with other conditions...

HAVING is not valid except with respect to GROUP BY.

./heLen