Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to I do a SUM on multiple fields
Message
De
31/08/2000 19:08:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to I do a SUM on multiple fields
Divers
Thread ID:
00411539
Message ID:
00411539
Vues:
52
I want to do a SQL SELECT and I want to do a group and then many sums on fields that will be a part of that group.

example:

FieldId Total1 Total2
1 2 3
1 4 5
2 3 2
2 1 2

the result that I would like to have after the select is

FieldId Total1 Total2
1 6 8
2 4 4


How do I do that?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform