In ArcGIS Pro 2.9.2 ModelBuilder, when attempting to run the Select Layer By Attribute tool after running the Add Join tool with a feature service as the input table, the error, "Error 000358: Invalid expression" is returned.

Workaround

There are no issues with running the Select Layer By Attribute tool in ModelBuilder after performing an Add Join operation with a feature service as the input table if the source is referenced from the Contents pane rather than a service URL.

Follow the steps below for the workaround.

1. In ArcGIS Pro, on the Map tab, in the Layer group, click the Add Data drop-down arrow and select the Data From Path option.
2. In the Add Data From Path window, insert the desired service URL, and click Add. The data appears in the Contents pane as Join1.
3. On the Analysis tab, in the Geoprocessing group, select ModelBuilder to open a new model.
4. Once the new model is open, under the ModelBuilder tab, in the Insert group, click Tools and search for Add Join. Drag the Add Join tool into the model.
5. Once the tool is within the model, right-click Add Join and select Open.... 
6. In the Add Join window, select Join1 for Input Table, and insert the desired URL for Join Table.
7. Open ModelBuilder and follow the same steps used to reproduce the issue. When following these steps again, there is no issue with running the Select Layer By Attribute tool whether the selection is written as a SQL expression or not.

Schritte zur Reproduzierung