waht is the best way to do this?
is it a pivot table
I have a table
studentid
club name
status
memberid
grade
I want to be able to show
student id and then for each club name i want to show clubname - status, clubmanem -member id, clubname - grade
what is the best way to do this