Hello!
I have a problem that I really could use some help to solve. I have a table
which looks like this:
id1, id2, id3, rate, ratenr
Examples of a select * from this table would be:
1047336399 21000 1 617 1
1047336399 21000 1 624B 1
1047336399 21000 1 621D 1
1047336399 21000 2 624B 1
1047336399 21000 2 612A 1
1047336399 21000 2 621D 1
1047336399 21000 3 617 1
1047336399 21000 3 624B 1
1047336399 21000 3 621D 1
I would like to transform this table into something like this:
1047336399 21000 1 617 1 624B 1 621D 1
1047336399 21000 2 624B 1 612A 1 621D 1
1047336399 21000 3 617 1 624B 1 621D 1
the three first columns should be the primary key.
Any help is appreciated
Gunnar