Subject RE: [firebird-support] COMPUTE
Author Alan McDonald
> so Guys...
> I consider that's not solve my little problem....

Why don't you write out a little table of field values and then show us what
result you want from them
Alan

>
>
> > > SELECT Salesman, clie, import
> > >
> > > FROM inquired
> > >
> > > ORDER BY Salesman, clie
> > >
> > > COMPUTE SUM(import) BY Salesman, clie?.
> > >
> > > COMPUTE SUM(import), AVG(import) BY Salesman
> > >
> > >
> > > [Non-text portions of this message have been removed]
> >
> >
> > SELECT SALESMAN, CLIE, SUM(IMPORT), AVG(IMPORT) FROM INQUIRED GROUP BY
> > SALESMAN, CLIE
> >