I'm new to Drupal, so my apologies if this is a newbie question, or if I'm applying SQL concepts to Drupal in an inappropriate way. What I'm trying to learn how to do is set up a many-to-one relationship in a view. I've found several tutorials that show how to do a one-to-many relationship -- for example, show a list of departments with a sub-list of employees in each department. What I need to do is go in the opposite direction.
Suppose I have the following content types:
* city (text)
* works_at (nodereference to office)
* salary (decimal)
How would I set up a view to show an employee with his salary field (from the employee node) as well as what city he works in (from the office node pointed to by the works_at nodereference field)?