I have the two tables.

The first table tbl1:

```
name nvarchar(255)
number nvarchar(255)

```

The second table dbo.phone\_codes:

```
country nvarchar(255)
code nvarchar(4)

```

The first query:

```
Select Name, Number
from dbo.tbl1

```

I am getting this result:

```
User1   375xxxxxxxx
User1   7xxxxxxxxxx
User2   49xxxxxxxxx

```

The second query:

```
select country, code
from dbo.phone_codes

```

I am getting result:

```
Belarus 375
Russian 7
Germany 49
Poland  48

```

What should I use the query if I want get this result:

```
User1   37552222222 Belarus 375
User1   77333333333 Russian 7
User2   49111111111 Germany 49

```

The first table:

```
name - nvarchar(255)
number - nvarchar(255)

```

The second table:

```
country - nvarchar(255)
code - nvarchar(4)

```