Basically in the end my intention is to have a table that looks something like this… (see image)
The first table(blue headers) is what I want in the end, but I’m not sure how to get the attendance for each player, for each of the 4 games listed to display as above.
I have 3 tables in use(yellow headers), a players table, a games table, and a signup table.
Now my problem is that I’m not sure how we can join the tables when I’m ordering by the player names AND by the games through attendance…:puzzle:
anyone have any ideas?
