Dear Experts

Eric goes to bazar and purchase some fruit and vegetable

Transcation is Table1 will be lool like as

--code---name-----qty-----credit-----Debit-----code2
1401001--Eric-------0---------0--------100--------3201001
3201001--Apple----10------100----------0--------1401001
1401001--Eric------0---------0--------200--------3202001
3202001--Potato-20--------200-----------0--------1401001

Now I want to get purchase summary as

--code---name-----qty---amount1--amount2
1401001--Eric-----30-----100--------200

amount1 is price of Fruit items, strarts with 3201
amount1 is price of Vegetable items, strarts with 3202

I wrote this statement but it displays all items

group_wise_sale =  "csr" + sys(2015)
select code,name,;
	sum(iif(left(code,4)='3201',cr_amount,0)) as amount_fruit_items,;
	sum(iif(left(code,4)='3202',cr_amount,0)) as amount_non_fruit_items;
	from table1;
	order by code ;
	group by code ;
	into cursor group_wise_sale

select group_wise_sale
brow