Hope you will have to write a procedure to do this. Within which you will have to query each separately and store the values in diff
variables and return it.

Cheers!!!
Vijay.G

 ann win wrote:Hi,
I am trying to create the following table with 3 column in using ASP
1> date
2> number responded
3> number done

for column 2, I have "select count(*) from respTable group by date"
for column 3, I have "select count(*) from respTable where isDone='Y' 
group by date"

I need to merge column 2 and column 3.
How can I write 1 sql statement that will return 1 recordset.

Thanks.
-ann


---------------------------------
Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs