In the future, new attributes could be added to the database so this is why I don't want to list them in a select statement.
Table
ID SUBJECT ATTRIBUTE
1 TEST CN
1 TEST TE
1 TEST AO
2 TESTING
3 PLACE_TEST CN
Results wanted
ID SUBJECT CN TE AO
1 TEST CN TE AO
2 TESTING
3 PLACE_TEST CN
Thank you for your help!
Table
ID SUBJECT ATTRIBUTE
1 TEST CN
1 TEST TE
1 TEST AO
2 TESTING
3 PLACE_TEST CN
Results wanted
ID SUBJECT CN TE AO
1 TEST CN TE AO
2 TESTING
3 PLACE_TEST CN
Thank you for your help!
