Hi there,

Can any body tell me about data shaping in ASP.Suppose

I have two tables joined and want to diaplay the

records group by some field and also sum of the

records group by same field.

The two tables are main and maindetail and the common

field(key) between them is orderkey and group by field

is catreference.

Can you help me in this regard.when I am using my sql

statement it is displaying all the records not

grouping it by catreference.

Thanx

--Arshad--