Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sum from fields in two tables
Message
From
16/11/2008 12:57:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sum from fields in two tables
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01362166
Message ID:
01362166
Views:
70
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é
Next
Reply
Map
View

Click here to load this message in the networking platform