Re: problem with creating a view translating rows to columns

Dot wrote:

> sample_id test1 test2 test3
> 1 1
> 1 1.25
> 1 0.23
> 2 1.25
> 3 34
> 3 67
>
> But what I really want is
>
> sample_id test1 test2 test3
> 1 1 1.25 0.23
> 2 1.25
> 3 34 67
>

Add a GROUP BY SAMPLE_ID at the and of your view definition.

Hope it helps
Bernard Received on Wed Aug 16 2006 - 10:54:35 CDT