enter image description here

I have two separate queries. One with about 20+ columns that also has an ID and a City.

I want to get the general area of each city in another column in this query, but each individual city has its own table. So I created a new query using UNIONs and got the query I need.

But now I want to add the second query to the first using the ID and City as the joining variables. Not sure how to do this, though.

I attached an image with my current query, what each table looks like alongside my UNIONed query, and the desired result

I UNIONed the 3 tables into a single one and now I am uncertain how I can JOIN the two queries into one, if possible. Could the UNION data be a subquery in the main query?