Re: [SQL] transposing data for a view

o get around this limitation? thanks, jeremy Arian Prins <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > H Jeremy Bockholt schreef: > > > I have a generalized table: > > > > scanid | region | volume > > - > &

[SQL] transposing data for a view

I have a generalized table: scanid | region | volume - 1 A 34.4 1 B 32.1 1 C 29.1 2 A 32.4 2 B 33.2 2 C 35.6 . . . I want to create a flattened out view that looks like the following: sca