Jump to content

sql, join rows


Recommended Posts

Hello, hope someone can help me out here


I have a table,



Table Scores




First I want to join the rows on ID when the score is the same, so that in the example below ID 2 has one row.




But is it also possible to remove the score column and put the score in the different year-columns as below?



Thank you

Link to comment
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.