Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sum from fields in two tables
Message
De
16/11/2008 12:57:35
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sum from fields in two tables
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01362166
Message ID:
01362166
Vues:
69
I have to sum two fields. Same field name but in two different tables.

Right now I sum and join but I end-up with two sums for the same Id.

How do I sum everything without intermediate sums (because of the joins) ?

I guess that "where in (select...) would be involved but I'm sot sure how to build this.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform