sql help needed

Its been a few weeks since I last posted, and its been a over a week since I 
was even at work....actually I kind of missed a lot of you :) Trying to get 
some rest and recoup time in a hospital bed just does not seem to ever work.

Alas, I am back, working on another stupid SQL problem.  If someone could 
point me in the right direction on this I would appreciate it.

I need to extract a sum of our line items for two separate date ranges, IE: 

select sum(ilneprice) as current from speclf where ilninvdate >'02/01/2005' 
and ilninvdate <='10/31/2005'

That works just fine, but I also need to extract a sum for the same field 
(ilneprice) for a different date range....is it possible to do this without 
having to run the query two separate times? Because I also need to extract 
some other information and group it by location codes and item numbers....

Any help would be appreciated.

Douglas


If you bought it, it was hauled by a truck - somewhere, sometime.