So the only difference is that WHERE is rushmore optimizable but
HAVING is NOT rushmore optimizable ?
Why there is a such difference in VFP ?
Can HAVING without group by used in all SQL servers ?
>Andrus,
>
>Mark is right - you are better off using WHERE.
>
>WHERE selects only those records that meet the specified condition and retrieves only those records.
>
>HAVING retrieves all records and then throws away the records it doesn't need. That means you have the "cost" of bringing way too much data over the network.
>
SELECT ;
> < complex expression > ;
> FROM MyTable ;
> WHERE BETWEEN(MyValue, 1, 1000) ;
> INTO CURSOR MyCursor ;
> ORDER BY MyOrder
>
>
>>Using having without group by
>>
>>Is it OK to use having without group by in SQL SELECT ?
>>
>>I want to place additional filter to result columns,
>>like:
>>
>>Select ;
>>
as myvalue, ;
>> from mytable ;
>> having betw( myvalue, 1,100 )
>>
>> is a very complex expression and i don't wish to include it to having clause second time.
Andrus