What is the syntax for nesting a query in mssql2005

[David Laffin]

In the following query I want to pull the same data (Qty, Line Total & Gross Profit)for a different date range and append it to the right of the data range so I have the data for 2 periods of time. What is the syntax for nesting this?

SELECT c.SlpName, a.CardCode, a.CardName, INV1.ItemCode, b.ItemName, Sum(INV1.Quantity), Sum(INV1.LineTotal), Sum(INV1.GrssProfit)
 
FROM CALLHAVEN.dbo.INV1
 
Left outer join CALLHAVEN.dbo.OINV a on INV1.DocEntry = a.DocEntry 
Left outer join CALLHAVEN.dbo.OITM b on INV1.ItemCode = b.ItemCode
Left outer join CALLHAVEN.dbo.OSLP c on INV1.SlpCode = c.SlpCode
 
WHERE (INV1.DocDate Between {ts '2010-03-01 00:00:00'} And {ts '2010-08-31 00:00:00'}) and SlpName = 'Bob Middleton'
 
GROUP BY c.SlpName, a.CardCode, a.CardName, INV1.ItemCode, b.ItemName