I have 2 tables.

Table Heroes - 2 records

```
Name NVARCHAR(50)
PowerIds NVARCHAR(50) 

Name               PowerIds
'Hulk'             '1,3'
'Reed Richards'    '2'

```

Table Powers - 3 records

```
PowerId INT
PowerDescr NVARCHAR(50)

PowerId   PowerDescr
1         'Strength'
2         'Intelligence'
3         'Durability'

```

What would be the smartest way to achieve this in a SELECT:

```
Name               Powers
'Hulk'             'Strength, Durability'
'Reed Richards'    'Intelligence'

```

**I cannot change the table structure, since this is a third party product.**