|Subject||RE: [firebird-support] Simple SQL question|
>That's not the same query, you're retrieving row count from table1, the
> 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
original query wants row count on a set based on table1.