Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING phrase
Message
From
11/06/2008 10:29:41
 
 
To
11/06/2008 10:17:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01323049
Message ID:
01323087
Views:
13
AHA!

>>Guess I gave up too quick.
>>
>>That's a good solution.
>>
>>Curiously, now that I see it, it's obvious.
>>
>>And it also explains to me why the field name confusion, since the HAVING clause allows reference to fields in the source table (for calculations like this one ...)
>>
>>Thanks
>>
>_____
>James,
>
>You're welcome.
>
>I know that 'construct' since I use it like in
>
>select product ,;
>      sum(realcost) ;  && no field name given
>   from ... ;
>   into array aa ;
>   group by 1 ;
>   having ( sum(realcost) > 222 )
>
Jim Nelson
Newbury Park, CA
Previous
Reply
Map
View

Click here to load this message in the networking platform