Josh,
I don't see how you got the result you quote below.
My query sums the volume figures, grouping by scanid:
that worked as expected (one line per scanid) on my
system when I tested it (version 7.1.2, though I don't
think that matters).
Jeff
--- Josh Berkus <josh@agliodbs.com> wrote:
> Of couse, it's only *half* a solution. Your query
> will result in:
>
> scanid A_volume B_volume C_volume
> 1 34.5
> 1 55.1
> 1 12.3
> 2 11.1
> etc.
>
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com