|
I have a table that looks something like:
ID Command ExitCode
----------------------------------
1 notepad 0
2 notepad 0
I am trying to write a query that will return the number of successes and exit codes for each command. I can do this perfectly in two queries but I need to do this in a single query. I'm very new to SQL and just started reading about joins yesterday. I haven't been able to accomplish what I want. The two queries that I've been using are:
SELECT COUNT(ID) AS [Failure count], Command
FROM table1
WHERE ExitCode<>0
GROUP BY Command
ORDER BY [Failure count] DESC
This returns:
Failure Count Command
-------------------------------------
10 Notepad
5 Wordpad
SELECT COUNT(ID) AS [Success count], Command
FROM table1
WHERE ExitCode=0
GROUP BY Command
ORDER BY [Success count] DESC
This returns:
Success Count Command
---------------------------------------
500 Notepad
302 Wordpad
I am trying to write a query that will combine those two results and produce the following:
Failure Count Command Success Count
------------------------------------------------------------
10 Notepad 500
5 Wordpad 302
Is there anyone out there who may be able to help? Thanks in advance, it's very much appreciated!
| 
