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 <elni...@yahoo.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, > >
