I have the 2 tables:

```
Games tbl                       Official tbl
Id    Ref1   Ref2   Ref3       RefId        Name
------------------------       ---------------------
1      1      3      2           1           Jaz
2      2      1      3           2           Rog
3      1      2      3           3           Dan

```

If a game is selected I need to get Ref Names as separate entries for that game, for example:

```
Game 1 - Ref1 = Jaz         Game 2 - Ref1 = Rog
         Ref2 = Dan                  Ref2 = Jaz
         Ref3 = Rog                  Ref3 = Dan

```

I have tried the sql below, but it seems to only get Ref1 and not Ref2 or Ref3:

```
Select a.Ref1, a.Ref2, a.Ref3 
From Games a 
Inner Join Official b On a.Ref1 = b.RefId 
Where a.Id = @Id

```