Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING phrase
Message
 
 
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:
01323084
Views:
10
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 )
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform