00226: In-memory joins are not supported

Your layer has an associated join that was created in the map. Sharing web feature layers with in-memory joined attributes is not supported.

Solutions

Use the following solutions:

• If your layer and joined data are in the same geodatabase, create a relationship class between the datasets instead of using an in-memory join. For more information about relationship classes, see An overview of the Relationship Classes toolset.
• Do one of the following:
  • Use the Create Database View tool to create a view. A view is a stored query that selects data from specified tables.
  • Export your layer with the join to a new feature class and use this new feature class in the map.
    1. Select the layer in the Contents pane.
    2. On the Feature Layer tab set, click the Data tab.
    3. In the Export group, click the Export Features button .
  • Remove the joins from your layer.
    1. Select the layer or table in the Contents pane.
    2. On the Feature Layer tab set, click the Data tab. (Alternatively, if you selected a table, the Standalone Table tab appears.)
    3. In the Relationship group, click the Joins menu .
    4. Click Remove Join.

Additional information

For more information, see Overview of joins and relates and Analyze your GIS resource.