RE: SQL group by on result fields

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

Nope, that was the one from the archives I tried.  It says "keyword WITH not
expected".

Thanks anyway, though.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com

<clip>
With Slt1 as (Select year(datefield) as DatYr,
                           month(datefield) as DatMo,
                           numeric1
                  from file)
Select DatYr, DatMo, Sum(numeric1)
>From Slt1
Group By DatYr, DatMo
<clip>