I have two recordsets that I am counting the data from the same table with different search criteria. I would like to join Org, FinApp, RootCause in the one table. Could you help me how to do that?

Thanks...

Here is the my select statements that I am counting the data from database:

strListFinAppCounts = "SELECT strOrg as Org,count(nID) as FinApp from tblCycleCount where dDateApproved = 'n/a' and dDateRecount = 'n/a' and (dDateRejected = 'n/a' or dDateRootCaused <> 'n/a') group by strOrg"
set rsListFinAppcounts = Server.CreateObject("ADODB.Recordset")
rsListFinAppCounts.Open strListFinAppCounts, oConn1

strListRootCounts = "SELECT strOrg as Org,count(nID) as RootCause from tblCycleCount where dDateApproved = 'n/a' and dDateRejected <> 'n/a' and dDateRootCaused = 'n/a' group by strOrg"
set rsListRootCounts = Server.CreateObject("ADODB.Recordset")
rsListRootCounts.Open strListRootCounts, oConn1

I'm not sure I understand what you are looking for. What do you mean by wanting to "join ... in the one table"? What does "join" mean in this context?

Remember that the COUNT function counts rows, and the WHERE clause selects which rows are being counted. Since your two queries are each counting the number of rows by selecting entirely different sets of rows, I don't think they can be "joined" together in any meaningful way into the same 'output' row(s)...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

I am not sure what I assume in this case is correct.

I think erin means to "sum up" those two count outputs by saying "join"

Is that so erin?


-Vijay G