Views 2 - Joining mutiple tables in a query

Hi,
I am trying to create a custom view out of multiple tables in my database. I am NOT using CCK. I have installed Table Wizard module and were successfully able to add relationships between the primary/foreign keys between the different tables. Here is an example of what I am trying to do:

Having let's say 3 tables with a list of fields:
Tbl Person ====> PersonID (PK), LocationID ( FK referencing LocationID in Location tbl)
Tbl Location ====> LocationID (PK), CItyID ( FK referencing CityID in City tbl).
Tbl City =====> CityID (PK).

When I create a new view, and choosing the Location Tbl as a view type (rather than node, comment, user....etc). I could successfully see all the other fields in both the Location tbl and the City tbl. Same thing if I choose the Person tbl, I could add all the fields from both the Location tbl and the Person tbl to my view.
My problem is, i cannot figure out a way to connect the Person tbl and the City tbl in one view.

Is there a solution??? thanks in advance.

_{edited by silverwing- changed forum}