Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING phrase
Message
From
11/06/2008 10:32:02
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01323049
Message ID:
01323088
Views:
10
I know that - just wanted to show how I found out
__
>Nothing prevents you from using a field alias in your example.
>
>>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 )
>>
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform