Need Help in sql query

[Nitin]

I have two resultset in asp as follows

AttributeText

700 Kbps
128 Kbps
$59.99
15 Months
15 Months
$499.98
- $100
$399.98

1 Mbps
200 Kbps
$69.99
15 Months
15 Months
$499.98
- $100
$399.98

1.5 Mbps
200 Kbps
$79.99
15 Months
15 Months
$499.98
- $100
$399.98

1.5 Mbps
300 Kbps
$99.99
15 Months
15 Months
- $100
$699.98

2.0 Mbps
500 Kbps
$179.99
15 Months
15 Months
$799.98
- $100
$699.98

Attribute Description

Max. Download Speed
Max. Upload Speed
Monthly Fees
Term Commitment
Hardware Warranty
Equipment and Standard Installation
Mail-In Rebate
Your Final Cost


I want to display output as follows

Max. Download Speed 700 Kbps 1
Mbps 1.5 Mbps -- --
Max. Upload Speed 128 Kbps 200
Kbps 200 Kbps -- --
Monthly Fees $59.99
$69.99 $79.99 -- --
Term Commitment 15 Months 15
Months 15 Months -- --
Hardware Warranty 15 Months 15
Months 15 Months -- --
Equipment and Standard Installation $499.98 $499.98
$499.98 -- --
Mail-In Rebate - $100 -
$100 - $100 -- --
Your Final Cost $399.98
$399.98 $399.98 -- --

Is this possible with asp code or i will have to change my database
design

Thanks in advance

Nitin

 

[Duane Hookom]

I'm not sure why you posted an "ASP" question with a "query" subject line in
an Access Reports news group.

You might find success elsewhere.