Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complicated Query
Message
From
11/12/2008 11:43:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Complicated Query
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01366648
Message ID:
01366648
Views:
52
Dear Experts

I have folloiwng database
create cursor temp(vou_no n(6), acc_code c(7),party c(1),qty n(8),rate n(7,2),cr_amount n(15,2))

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3322,'3201003','A',50,460)

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3322,'3202001','B',95,410)

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3322,'3206003','C',1,1415)

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3322,'3207001','D',2,1415)

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3323,'3201003','A',20,460)

insert into temp(vou_no,acc_code,party,qty,rate);
	values(3323,'3202001','B',25,410)
To make group I use following codes
select vou_no,acc_code,party,sum(qty)as qty,sum(qty*rate)as cr_amount;
	from temp;
	order by vou_no,party;
	group by vou_no,party;
	into cursor temp2
But....
I want to get result as follows

vou_no--a---b---c---d---cr_amount

3322---50---95--1---2----66195
3323---20---25--0---0----19450


Please help
Next
Reply
Map
View

Click here to load this message in the networking platform