Combining miltiple rows in one

[Anfel]

I have a table with 4 TitleNames like

TitleKey TitleName
1 WA
2 WD
3 OY
4 YY

Whe I'm doing select statement I need concatinate or combine "WA" and "WD". Then I have to create another select statement where I can use this concatination.

Any help would be appreciated

 

[wilk]

You can try just doing it like this.

select forename + surname as name from table