10007: Label class value has an SQL query that uses unqualified field names for fields that exist in more than one table

Your map layer has a label class with a SQL query that uses unqualified field names for fields that exist in more than one table. Ambiguous field names in more than one table of a join will give unknown results when used for draw and query operations.

Solution

• First, check the drawing performance of your basemap layer in ArcMap or your map service in the Preview window. See Working with basemap layers or Publishing map services for more information.
• If you see the need to make changes, provide a more qualified field name to identify the specific table to use.

More information

You can append the table name to the field name to provide a qualified name for the field you want to use.

Specify field names as TableName.FieldName.

This naming convention helps prevent duplicate field names when the target dataset and a join table have common field names.