ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

00120: Query table has a complex query

  • Solution
  • More information

Your stand-alone table is a query table defined by a complex SQL query, and you are publishing to ArcGIS for Server.

Solution

  • Change the SQL query so that it is no longer complex. The query should be simple. A common example would be as follows: SELECT * FROM Test.dbo.US_States.
  • Alternatively, you can remove the stand-alone table if it is not needed.

More information

Publishing to ArcGIS for Server requires that the SQL query defining the query table be simple. A common example would be as follows: SELECT * FROM Test.dbo.US_States. A simple query can contain a subset of the fields in the table, for example, SELECT objectid, pop2000, pop2010 FROM Test.dbo.US_States. WHERE clauses and joins are unsupported when publishing; for example, you cannot publish a query table where you are selecting a subset of rows in a simple query because it is controlled by the WHERE clause.

Learn more about authoring feature services for ArcGIS for Server

A query layer is a layer or stand-alone table that is defined by an SQL query. Query layers allow both spatial and nonspatial information stored in a DBMS to be easily integrated into GIS projects within ArcMap. Since query layers are using SQL to directly query database tables and views, spatial information used by a query layer is not required to be in a geodatabase.

When working in ArcMap, you create query layers by defining an SQL query. The query is then run against the tables and views in a database, and the result set is added to ArcMap as a layer or stand-alone table (depending on the query).

Learn more about query layers and creating a query layer

Learn more about authoring feature services for ArcGIS for Server

Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal