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.
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.
Is there another way to do this? Am I missing something?
