SQL Join to put rows into columns
Here is one of the ways to do it!

First you need to convert the t2 table as columns provided you are certain about the values of the game.

SELECT
    max(CASE WHEN game = 'A' THEN game END) GAME1,
    max(CASE WHEN game = 'B' THEN game END) GAME2,
    ID 
FROM T2 GROUP BY ID


This will give you something like 

 game1 game2   ID
  A      B    1001
  A     NULL  1002


Now join this with your t1.

SELECT t1.id, t1.name, S1.GAME1, COALESCE(S1.GAME2, '') FROM t1
    JOIN (SELECT
                max(CASE WHEN game = 'A' THEN game END) GAME1,
                max(CASE when game= 'B' THEN game END) GAME2,
                ID FROM T2 GROUP BY ID) S1 
        ON t1.id = S1.ID


Keep in mind that this will be more lengthy when the game types increase.