Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING phrase
Message
From
11/06/2008 10:17:37
 
 
To
11/06/2008 10:12:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01323049
Message ID:
01323082
Views:
12
>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 )
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform