https://community.esri.com/t5/arcgis-pro-questions/create-query-table-sql-expression/m-p/1190877#M57077 <P>I had a model in ArcMap that used the SQL expression to create a many to one join. I was taking a non-spatial table and assigning work order to a spatial building layer. Sometimes there was 50+ records associated with a building and sometimes none. I built a tool that updated the data twice a week using an export from a larger database system. In ArcMap, I used the SQL expression to match the buildings to the work order using the statement BuildingID = WorkOrderID with the building ID and work order ID being attributes in the table and spatial data.</P><P>I am trying to migrate all my data and processes to ArcPro, however I can no longer use the SQL statement which follows the structure of attribute=attribute. When I validate the expression, it says it is valid. However, when I run the tool, I get an error saying that the statement is not valid. None of the data has changed between ArcMap and Pro except which database it is getting saved to.&nbsp;</P><P>Is there another way to do this? Am I missing something?</P> Fri, 08 Jul 2022 16:00:11 GMT JoanneStarr 2022-07-08T16:00:11Z https://community.esri.com/t5/arcgis-pro-questions/create-query-table-sql-expression/m-p/1190877#M57077 <P>I had a model in ArcMap that used the SQL expression to create a many to one join. I was taking a non-spatial table and assigning work order to a spatial building layer. Sometimes there was 50+ records associated with a building and sometimes none. I built a tool that updated the data twice a week using an export from a larger database system. In ArcMap, I used the SQL expression to match the buildings to the work order using the statement BuildingID = WorkOrderID with the building ID and work order ID being attributes in the table and spatial data.</P><P>I am trying to migrate all my data and processes to ArcPro, however I can no longer use the SQL statement which follows the structure of attribute=attribute. When I validate the expression, it says it is valid. However, when I run the tool, I get an error saying that the statement is not valid. None of the data has changed between ArcMap and Pro except which database it is getting saved to.&nbsp;</P><P>Is there another way to do this? Am I missing something?</P> Fri, 08 Jul 2022 16:00:11 GMT https://community.esri.com/t5/arcgis-pro-questions/create-query-table-sql-expression/m-p/1190877#M57077 JoanneStarr 2022-07-08T16:00:11Z