Relating two Drupal 7 views filters

Question

Say there are two Drupal 7 views exposed filters, one called People, another one called City. If I select one city from the City filter, then the people in the People filter should only contain people who live in the selected city.

This is very simple in SQL:

select * 
from People
left join City
on People.city_id = City.id
where City.id=xxx;

How can I do this with exposed filters in Drupal 7 views?

Answer 1

I think Hierarchical Select can do the trick. You can specify fields dependency.