Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-Select that sums
Message
From
06/02/2003 17:51:55
Winn Pauley
Sandy, Utah, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL-Select that sums
Miscellaneous
Thread ID:
00750295
Message ID:
00750295
Views:
60
Hi All,
I have a table that is a collection of items that I need to sum. 

lotname   line   item   lbs
PUTR        1      1     0
PUTR        1      2     0
PUTR        1      3    7.3
PUTR        1      4    177.1
PUTR        1      5    15.5
CELA        2      1     0
CELA        2      2    179.6
CELA        2      3    20.4
ATCA        3      1    27.4

What I am wondering is how I can sum lbs for each line number in a select statement. Anyone have any ideas? 
TIA,


Winn Pauley
Next
Reply
Map
View

Click here to load this message in the networking platform