I have two tables here:

```
Table1
Version | Position | PIN
1       | 1        | 1111
1       | 2        | 2222
2       | 1        | 3333
2       | 2        | 4444

```

I have another table

```
Table2
Name     | Version | Position1 | Position2
'Phone1' | 1       | A         | B
'Phone2' | 2       | C         | D

```

Actually Table2.Position1 = (Table1.Position=1) and Table2.Position2 = (Table1.Position=2). Also Table1.Version = Table2.Version.

I would like to make the view that looks like this

```
Table3
Name     | P_Name   | PIN
'Phone1' | A        | 1111
'Phone1' | B        | 2222
'Phone2' | C        | 3333
'Phone2' | D        | 4444

```