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:
00437775
Views:
25
>Ko,
>
>Your result is not what I want:
>
>Sample:
>1999 01 20
>1999 01 30
>1999 03 40
>2000 01  10
>2000 01  15
>2000 02  20
>2000 03  10
>
>Result should be:
>1999 01  50  2
>1999 03  90  3
>2000 01  25  2
>2000 02  45  3
>2000 03  55  4
>
>
>See the difference with your result?


Eh?

No?

Mines gave that result.
Look at the sample values i provided, and look out that in the second table the fields aren't sorted yet.
Previous
Reply
Map
View

Click here to load this message in the networking platform