Re: transposing data for a view

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