Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to I do a SUM on multiple fields
Message
From
31/08/2000 19:08:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to I do a SUM on multiple fields
Miscellaneous
Thread ID:
00411539
Message ID:
00411539
Views:
51
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é
Next
Reply
Map
View

Click here to load this message in the networking platform