Hi to everyone,
I have a problem figuring this out... my db is arranged like this
Competitors 1st choice 2nd choice 3rd choice John Basket Baseball Kayak Mary Kayak Basket Stephen Basket Baseball Golf
and I need to figure out this
Sport 1st choice 2nd choice 3rd choice Basket John;Stephen Mary Baseball John;Stephen Golf Stephen Kayak Mary John
I have a non definite number of different "Competitors", and a definite number of different "sports" (33).
Each competitor have up to 33 choices, but no "sport" can be entered twice by the same "competitor".
I can get the total amount of e,g, "first choices" for each "sport", but I'm currently stuck at getting the precise "competitor group per priorità of choice per sport", any help?
Bookmarks