Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complicated SQL - can we make it?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00437328
Message ID:
00437518
Views:
35
Ko,
>
>Interesting. I'll try tomorrow. Seems simpler, than I originally anticipated. Thanks a lot. BTW, your select seems to be incorrect, as I've analyzed now.
>But I got the idea and try to make it work.


Eh,

Incorrect?
What do you mean? That the output didn't give you the result you want?
What i send you will give you the total amount from the first month to the current month like:
month total
01 total month01
02 total month01 and 02
etc.
That's what i get out of your post.
I'm sorry if i didn't understood you correctly.

If you only want the totals per month it is much simpler.
You only have to change the second expression in the where clause.
The SQL i told gave the listed result.

Another thing that can be done better is the arrangement of the dummy field.
If you first place the year, and then the month you can also sort on that field.
But i simply typed in the SQL from scratch and tried first to get it to work.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform