Обсуждение: Select and merge rows?

<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello!<br />I have a
doubtabout a query that I tried to do, but I cant......<br />This is the scenario:<br />I have a table, with this
rows:<br/>order    ID    value    <br />----------------------<br />1    1000    3<br />2    1000    5<br />3   
1000   6<br />1    1001    1<br />2    1001    2<br />1    1002    4<br />2    1002    4<br /><br />I need to get this
table,divided by ID, like this:<br />id    value1    value2    value3<br />--------------------------------<br
/>1000   3    5    6<br />1001    1    2<br />1002    1    2<br /><br />How I can do this?<br />I tried with cursors
andview, but i can't....<br />Any help is welcome!<br /><br />Thanks in advance!<br />Regards,<br /><br
/></td></tr></table>

Howdy!

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

Best,
Oliveiros