Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Result without group by
Message
From
13/07/2005 00:56:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Result without group by
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01032051
Message ID:
01032051
Views:
70
Dear Experts

I have table1, containing data as follows

month pen pencil book
jan 15 20 35
feb 27
feb 37 16
mar 5 7 98
apr 47
apr 46
apr 45


In table1, month feb and apr comes more than one times. If a month comes more than one times then data of other records of the same month should come in first occourance in related fields. I do not want to use command like select sum(pen). The result should look this

month pen pencil book
jan 15 20 35
feb 37 27 16
mar 5 7 98
apr 45 46 47

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform