Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order by date, group by cusomerid
Message
From
23/06/2003 07:12:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Order by date, group by cusomerid
Miscellaneous
Thread ID:
00802828
Message ID:
00802828
Views:
52
Who can help me?
I have a table 'custdetails' with the following fields: Shipdate,customerid.
I want to fill grid with how many NEW customer I had every day.
I rununing the following syntax:
select * from custdetails order by shipdate into cursor tmp1 nofilter
select * from tmp1 group by customerid into cursor tmp2 nofilter
Select shipdate,count(customerid) from tmp2
My problem is that I get the late shipdate not the first (if person has shipdate for today and for yesterday he will be counted as yesterday).
What can I do?
Thank you for help
Chaim
Thank you
Chaim
Next
Reply
Map
View

Click here to load this message in the networking platform