I cannot explain this thoroughly with words as English is not my native language so I will try visual presentation. First, I have a table that looks like this let's call it `tblPerson`:

```
tblPerson
ID   Name
1    John
2    Paul
3    James

```

Then I have another table `tblPhones`:

```
tblPhones
ID   Mobile
1    123456
2    654321

```

Now for my question, is it possible to create a view that will look like this:

```
Person-Phone
Name    Mobile
John    123456
Paul    654321
James   123456

```

What I want to display is a list of person, and use the tblPhones to assign the mobile column but assign it alternately. So if a new person is added lets say `Mark`. The view would look like this:

```
Person-Phone
Name    Mobile
John    123456
Paul    654321
James   123456
Mark    654321

```

How can I query this?