>
> I would have done it like this:
>
> Select t1.Field1, t1.Field2, SUM(t1.Field3),
> (select count(*) from table1 t2) as totalcount
> from t1.Table1
> Group by 1,2
>
>

That's not the same query, you're retrieving row count from table1, the
original query wants row count on a set based on table1.

Sasha