I am learning myself to program with SQL and I have a problem which I can't solve.
I have a few rows which I need to transfer to columns, see below.
The table looks like this
Order sub ID status
609011 01 01 R
609011 01 02 P
609011 01 03 R
There can be more ID's per Order en sub.
I like to choose the ID, which I will need in a column, like below.
In this example only ID 01 and 02.
Order sub ID Status ID Status
609011 01 01 R 02 P
I hope you understand what I mean, sorry if it is not all clear.