# Trickey join

**URL:** <https://forum.kirupa.com/t/trickey-join/311255>\
**Category:** programming\
**Created:** [July 1, 2010, 9:36am UTC](https://forum.kirupa.com/t/trickey-join/311255 "2010-07-01T09:36:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![crayzee](https://avatars.discourse-cdn.com/v4/letter/c/919ad9/32.png) [@crayzee](https://forum.kirupa.com/u/crayzee)\
**Post date:** [July 1, 2010, 9:36am UTC](https://forum.kirupa.com/t/trickey-join/311255/1 "2010-07-01T09:36:07Z")

</div>

Basically in the end my intention is to have a table that looks something like this… (see image)

![](http://wardconcepts.com/images/sql_problem.jpg)

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?