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)...
Custom Apps, Inc.