Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
HAVING phrase
Message
De
11/06/2008 10:17:37
 
 
À
11/06/2008 10:12:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01323049
Message ID:
01323082
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform