I'm using Micorsoft SQL Server Managment Studio 08

I have a query that pulls a bunch of tables together into 2 columns. A list of user Codes in Column A and a list of to letter codes in Column B

```
ColA     ColB

user1 aa

user1 ab

user2 aa

user2 cc

```

So this represents what systems each user has access to. But I need to attach country codes to each of these codes before I can insert it back into a different table. So if I had five countries:

IE,GB,IT,FR,US

Id Like to Replace the first row from above with:

```
ColA     ColB

user1 IE.aa

user1 GB.aa

user1 IT.aa

user1 FR.aa

user1 US.aa

```

And so on for each other unique User/Code combo.I can have all these countries in a separate table easily enough if that makes it easier.

Kind Regards,
Colm