Retrieving a second field in the same query

[JustinThomason]

I hope I can coherently explain what I'm trying to achieve.

I'm working on a vault with a bunch of cross-referenced metadata, and I'm trying to leverage Dataview as much as I possibly can. One particular Dataview query is giving me problems. I have files for Places that include pertinent Persons associated with that Place in the front matter.

ex.: Place 1

---
fileType: Place
people:
 - Person 1
 - Person 2
---

Each Person has an Occupation noted in their file's front matter.

ex.: Person 1

---
fileType: Person
occupation: Occupation 1
---

I can get the concatenated names of Persons associated to a Place as links using a query like =join(link(this.people),"; ") which outputs each Person's name as a link back to their file followed by a semicolon and then the next Person's link.

What I would like would be to have an inline query that would concatenate each Person's name (as a link) followed by their Occupation (not a link) queried from the Person's file, followed by the next Person with their Occupation and so on.

i.e., [[Person 1]] Occupation 1; [[Person 2]] Occupation 2

I feel like there ought to be a way to do that, but I cannot figure out how.

[AB1908]

Can you share some example output? You can reference another page's fields like so [[Person 1]].occupation so that's part of the puzzle but this likely won't be enough to get it done since people is an array and you'd probably want to map() over it.