Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Getting the data from the first record while SUM()
Message
From
20/05/2004 12:51:42
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
20/05/2004 12:02:40
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL - Getting the data from the first record while SUM()
Miscellaneous
Thread ID:
00905669
Message ID:
00905692
Views:
13
Where is the GROUP BY clause ?
SELECT Product.id,
Product.nItem,
MIN(Product.tAddStamp) AS tProduction,
SUM(PRODUCT.nWeight_Item)
FROM PRODUCTON
INTO CURSOR crsSearchResults
Previous
Reply
Map
View

Click here to load this message in the networking platform