Apply join to whole mySQL table
===

I have two mySQL tables in my database

**Training:**

    +-------------+------------+------------+------------+-...-+------------+
    | Training_ID | 09-06-2012 | 16-06-2012 | 23-06-2012 | ... | 28-12-2013 |
    +-------------+------------+------------+------------+-...-+------------+
    |     1       |    123     |    924     |   367      |     |   679      |
    +-------------+------------+------------+------------+-...-+------------+
    |     2       |    243     |    626     |   381      |     |   771      |
    +-------------+------------+------------+------------+-...-+------------+
    |     3       |    766     |    826     |   956      |     |   725      |
    +-------------+------------+------------+------------+-...-+------------+
    

**Users:**

    +---------+----------+
    | User_ID | Name     |
    +---------+----------+
    |   123   | Fred     | 
    +---------+----------+
    |   924   | James    | 
    +---------+----------+ 
    |   367   | Tim      | 
    +---------+----------+
    |   766   | Mark     | 
    +---------+----------+


**What I want to show is:**

    +-------------+------------+-------------+------------+-...-+------------+
    | Training_ID | 09-06-2012 | 16-06-2012  | 23-06-2012 | ... | 28-12-2013 |
    +-------------+------------+-------------+------------+-...-+------------+
    |     1       | 123 - Fred | 924 - James | 367 - Tim  |     | 679 - Ben  |
    +-------------+------------+-------------+------------+-...-+------------+
    |     2       | 243 - Sarah| 626 - Smith | 381 - Exam |     | 771 - John |
    +-------------+------------+-------------+------------+-...-+------------+
    |     3       | 766 - Mark | 826 - Jone  | 956 - Case |     | 725 - Brett|
    +-------------+------------+-------------+------------+-...-+------------+


**Note:** there are actually 70 columns (all the same format as the above).

I tried using joins - but I cant do one for each column.

Is there a way to apply a join to the whole table?