title: SQL Combining several SELECT results
body: <p>I have three SELECT statements that each return a total, 'New Cases', 'Closes Cases', 'Existing Cases'. How do I combine these so they are returned in one resultset. </p>
  
  <p>ie I need a table returned with 3 fields, 'New Cases', 'Closes Cases' and 'Existing Cases' each with one total</p>
  
  <pre><code>SELECT     COUNT(CaseID) AS 'New Cases'
  FROM         dbo.ClientCase
  WHERE     (CaseStartDate &gt;= CONVERT(DATETIME, '2009-01-01 00:00:00', 102))
    AND     (CaseStartDate &lt;= CONVERT(DATETIME, '2009-03-31 00:00:00', 102))
  
  SELECT     COUNT(CaseID) AS 'Closed Cases'
  FROM         dbo.ClientCase
  WHERE     (CaseClosedDate &gt;= CONVERT(DATETIME, '2009-01-01 00:00:00', 102))
    AND     (CaseClosedDate &lt;= CONVERT(DATETIME, '2009-03-31 00:00:00', 102))
  
  SELECT     COUNT(CaseID) AS 'Existing Cases'
  FROM         dbo.ClientCase
  WHERE     (CaseStartDate &lt;= CONVERT(DATETIME, '2009-03-31 00:00:00', 102))
  </code></pre>