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,
