Is This Content Helpful?
We're glad to know this article was helpful.
Will Outer Joins work in the SPATIALQUERY Element for ArcIMS?
Yes. Outer joins work for tables joined to ArcSDE feature classes using the SPATIALQUERY element.
When joining database tables to ArcSDE feature classes, features that do not have matching records in the joined table are not rendered because ArcIMS instructs the database to perform inner joins.
If matching records do not exist in the joined table, and the desired outcome is the rendering of all features, the ArcIMS map configuration file or query should be configured to execute an outer join in the database.
For example, in the case of a table with 75 records joined to an ArcSDE feature class with 100 records, ArcIMS must instruct the database to perform a left outer join to render all features even though all of the features do not have matching records in the joined table. If a left outer join is not performed, only the 75 features with matching records in the table will be rendered.
To perform a left outer join in ArcIMS, the appropriate syntax must be used for the database being used, as demonstrated in the examples below.
· Oracle example: (+)
<SPATIALQUERY where="ARCIMS.REGIONS.JOINID = ARCIMS.EXPORTS.JOINID (+)" jointables="ARCIMS.EXPORTS" />
<SPATIALQUERY where="ARCIMS.REGIONS.JOINID *= ARCIMS.EXPORTS.JOINID" jointables="ARCIMS.EXPORTS" />
This does not work when using SQL Server 2005.