Using ArcGis Pro 2.9 to access an old oracle database. Trying to use the Edit Query Layer tool to create a local standalone table that pulls together all the data from multiple individual related tables on the database.
One particular table contains three columns. The data I want is in one column and is simply a list of city names. The other two columns in this city table are both lookup columns. One lookup field corresponds with facility physical addresses and the other corresponds with an owners address. So obviously the city may not necessarily be the same for each record.
Is it even possible to write a single select statement that incorporates the use of the CITY_NAME field twice with separate lookup values or do I need to use a different method?
