Re: Select and merge rows?

Howdy!

Is there a maximum ceilling of three values per order ID? or an ID can have
an arbitrary number of values?

Best,
Oliveiros

2011/5/5 Claudio Adriano Guarracino <elninon(at)yahoo(dot)com>

> Hello!
> I have a doubt about a query that I tried to do, but I cant......
> This is the scenario:
> I have a table, with this rows:
> order ID value
> ----------------------
> 1 1000 3
> 2 1000 5
> 3 1000 6
> 1 1001 1
> 2 1001 2
> 1 1002 4
> 2 1002 4
>
> I need to get this table, divided by ID, like this:
> id value1 value2 value3
> --------------------------------
> 1000 3 5 6
> 1001 1 2
> 1002 1 2
>
> How I can do this?
> I tried with cursors and view, but i can't....
> Any help is welcome!
>
> Thanks in advance!
> Regards,
>
>