https://community.esri.com/t5/arcgis-pro-questions/edit-query-layer/m-p/1217579#M60526 <P>Using ArcGis Pro 2.9 to access an old oracle database.&nbsp; 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.&nbsp;&nbsp;</P><P>One particular table contains three columns.&nbsp; The data I want is in one column and is simply a list of city&nbsp; names.&nbsp; The other two columns in this city table are both lookup columns.&nbsp; One lookup field corresponds with facility physical addresses and the other corresponds with an owners address.&nbsp; So obviously the city may not necessarily be the same for each record.</P><P>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?</P> Thu, 29 Sep 2022 19:32:14 GMT LeighErik 2022-09-29T19:32:14Z https://community.esri.com/t5/arcgis-pro-questions/edit-query-layer/m-p/1217579#M60526 <P>Using ArcGis Pro 2.9 to access an old oracle database.&nbsp; 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.&nbsp;&nbsp;</P><P>One particular table contains three columns.&nbsp; The data I want is in one column and is simply a list of city&nbsp; names.&nbsp; The other two columns in this city table are both lookup columns.&nbsp; One lookup field corresponds with facility physical addresses and the other corresponds with an owners address.&nbsp; So obviously the city may not necessarily be the same for each record.</P><P>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?</P> Thu, 29 Sep 2022 19:32:14 GMT https://community.esri.com/t5/arcgis-pro-questions/edit-query-layer/m-p/1217579#M60526 LeighErik 2022-09-29T19:32:14Z